Forum Discussion
Solved
How do I formulate a running count of the dates in my headers to today's date?
How do I formulate a running count of the dates in my headers to today's date but only the dates in my headers & only when today is in my headers? Since this is tracking for a school the dates jump o...
If the range B2:GX2 contains "real" dates, it should work.
If it contains text values that look like dates, for example if the range is the header row of a table, use
=SUM(--(DATEVALUE(B2:GX2)<=TODAY()))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
It is giving me a zero, do I need the dates formulated a certain way?
If the range B2:GX2 contains "real" dates, it should work.
If it contains text values that look like dates, for example if the range is the header row of a table, use
=SUM(--(DATEVALUE(B2:GX2)<=TODAY()))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
- This worked, for some reason when the dates are in my table it doesn't read the date format unless I double click on the date cell & do it for all of them, this way counted it right away, Thank you again for your help.