First and Last date of the last month

First and Last date of the last month

Extract just month from a cell – Here’s how

Adding years, months or days to a date – Here’s how

These bits of code will display the first and late date of the last month. Pretty handy for “Last Month” reporting needs.

Today isĀ 20/02/2017
Start of last Month
=TEXT(EOMONTH(TODAY(),-2)+1,”dd/mm/yyyy”)
Shows in the cell “01/01/2017”
End of last Month
=TEXT(EOMONTH(TODAY(),-1),”dd/mm/yyyy”)
Shows in the cell “31/01/2017”
Enjoy