Automate start and end of the month date

This code works along the same as the First and Last Month Dates but is for a rolling 12 month. Each month this code will change!

This code will display the 1st of the start of the rolling 12 months

=TEXT(EOMONTH(TODAY(),-13)+1,”dd/mm/yyyy”)

This code will display the last date of the last month for the rolling

=TEXT(EOMONTH(TODAY(),-1),”dd/mm/yyyy”)

Enjoy!