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