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.
I got it, I had to format it as dddd, mmmm d, yyyy & I just pasted it in a row under my table for calculation purposes. Thanks so much for your help.