April 18, 2024

MoDCore

Welcome to the core

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!

Copyright © All rights reserved. | Newsphere by AF themes.