Notifications
Clear all
Topic starter
I'm trying to create a 75 day rolling calendar. I need the previous day to fall off and the values with that day to fall off also so that they are not calculated in the 75 day total. I have attached an example of what I have so far. Appreciate any help.
Posted : 04/05/2017 12:02 pm
Hi
Give this a try.
In cell B2 enter =SUMIF($C$1:$BY$1,">"&TODAY(),C2:BY2). Copy the formula down as many rows as needed.
It will sum for dates greater than today's date.
Hope this helps.
Sunny
Posted : 04/05/2017 9:21 pm
Topic starter
That's a big help! Thank you very much!
Posted : 05/05/2017 9:05 am
