Work Out First Date of The Month

This formula allows you to work out the first date of a month based on the date in cell A1 and this can be changed to any cell in Excel. Handy for reporting. =DATE(YEAR(A1),MONTH(A1),1) And for the last day.

=DATE(YEAR(A1),MONTH(A1)+1,0)

Code Snippits