EOMONTH

Returns the last day of the month, shifted by the number of months given: EOMONTH(date,0) is the end of the same month and EOMONTH(date,-1) the end of the previous month. So EOMONTH(date,-1)+1 gives the first of the month. Also in Lec 04.

When to use

Used in the calendar and timesheet to find the last day of the chosen month without knowing whether it has 28, 29, 30 or 31 days, and in conditional-formatting rules such as $A15>EOMONTH($A$15,0).

See Lec 03.

Appears in

No references yet.