MrExcel.com - Your One Stop for Excel Tips & Solutions

FirstDayOfMonth + LastDayOfMonth Functions Wanted

Posted by RM on October 30, 2001 11:26 PM

I need 2 functions in Excel 5.0 that one can give the First Day Of a Month and the other one gives the Last Day Of a Month.

Posted by Bob Umlas on October 31, 2001 4:09 AM

Assuming you have the date in A1:
FIrst day of month: =Date(Year(A1),Month(A1),1)
Last day of month: =Date(Year(A1),Month(A1)+1,0)