Last day of month (97-2)

Topic

New Reply

Can anyone give me the function for finding the last day (date) of the month ? I have to make sure my users are entering the last day (date) of the month for any given month.
Thanks

Reply | Quote

Replies

Cathy: Try this:

=DateSerial(Year(Date()),Month(Date())+1,0)

Reply | Quote

Checkout this starred post. You can easily modify it for any particular date rather than just today’s date.

Reply | Quote