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.
In A2:
=LET(s, SEQUENCE(12), DATE(YEAR(TODAY())+(s<MONTH(TODAY())), s, 1))
Apply the custom number format mmmm yy to A2:A13.
Incredible thanks HansVogelaar - and quick too!
Second question:
Is there a way in cell C1 for example, to display the current FY based on the date?
The current financial year starts on 1st March. Therefore in cell C1, based on todays date, it would be 01/03/2024 formatted to mmmm yy (March 2024)
If todays date was 6th April 2025, cell C1 would register as 01/03/2025
Is this possible too?
Or:
=DATE(YEAR(TODAY())-(MONTH(TODAY())<3), 3, 1)
As variant
=LET( d, TODAY(), m, MONTH(d), EOMONTH(d, 2-m-12*(m<3))+1 )Thank you - much appreciated
