Forum Discussion
Solved
Automatic Rolling 12 Month List
Hi all I've looked first but nothing seems to give me what I am looking for. Hope you can help! I'm simply looking for a rolling 12 months list that automatically updates based on the current date...
In A2:
=LET(s, SEQUENCE(12), DATE(YEAR(TODAY())+(s<MONTH(TODAY())), s, 1))
Apply the custom number format mmmm yy to A2:A13.
As variant
=LET( d, TODAY(), m, MONTH(d), EOMONTH(d, 2-m-12*(m<3))+1 )
Thank you - much appreciated