EOMONTH Formula in Excel

What Does It Do?

This function will show the last day of the month which is a specified number of months before or after a given date.

image

Syntax

=EOMONTH(StartDate,Months)

Formatting

The result will normally be expressed as a number, this can be formatted to represent a date by using the Format,Cells,Number,Date command.

No comments:

Post a Comment