For example, to determine the serial date number for the last day of the current month, use
To avoid using the EOMONTH formula, you can use the fact that the zeroth day of the next month is the last day of the current month:
There are many ways to do this, such as subtracting a day from the first day of the next month:
Of course, NOW() could be replaced with a reference to a date cell, or in the case of the last formula ...
=DATEVALUE((month+1)&"/1/"&year)-1where month and year are named references to cells.