Notifications
Clear all
Dashboards & Charts
3
Posts
2
Users
1
Reactions
201
Views
Topic starter
Hello, I have created a dashboard with the dynamic period (Daily, Weekly, Monthly) following along with the formulas.
Daily and weekly display fine in the trial area, however the Monthly is reverting to 1900?
Any help is appreciated, thank you
Posted : 19/12/2024 3:33 pm
Your file links to another one on your own system ([Master Project Dashboard Rik Update DO NOT DELETE.xlsx]) so I can't see what's being picked up by the 'year' function.
=DATE(MIN(YEAR(DataB!D2:D99)),SEQUENCE(1,26,1),1)
But I suspect that the MIN function always returns 0. Thus, the DATE function becomes:
=DATE(0, {1, 2, 3, etc. , 26}, 1)
And year 0 in the Excel calendar = 1900
Posted : 20/12/2024 2:10 am
Rik Lelliott reacted
Topic starter
Thank you Riny, much appreciated !!
Posted : 07/01/2025 5:02 am
