Now let's have a look at some of the examples of the EOMONTH function in Excel. The cell containing the EOMONTH function’s output must be formatted as a date since the function will output a serial number.For obtaining a date n months from the initial date, use the EDATE EOMONTH returns the last day of the month, which is computed by adding/subtracting n months to/from the initial date.If the date in the start_date argument has a time element, the EOMONTH function will ignore it.It will return a #VALUE! error if the supplied date is non-numeric. If the start_date argument is not a valid serial number that Excel recognizes as a date, the EOMONTH function will return a #NUM! error.Inputting a positive number in the months argument produces a future date, and inputting a negative number produces a date in the past.Important characteristics of the EOMONTH function Months – A negative or positive number representing months to be added to or subtracted from the value in the start_date. ![]() ![]() If it is entered as text, Excel will return an error. It must be a valid date, i.e., a serial number that Excel recognizes as a date. Start_date – This is a value that represents the start date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |