Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
227
Views
Topic starter
'=TEXT(SEQUENCE(12,1,DATE(2024,3,1), 1),"mmm yyyy") I cannot find the error. The formula starts with Mar 2024 but instead of increasing by 1 month through to feb 2025 it gives the Mar 2024 11 times.
Posted : 07/12/2024 9:25 am
Hello,
You should move in the SEQUENCE part to the month section in the DATE function, as in below example:
=TEXT(DATE(2024,SEQUENCE(12,1,3,1),1),"MMM YYYY")
Br,
Anders
Posted : 10/12/2024 4:39 pm
Topic starter
thks
Posted : 12/12/2024 4:25 am
