What I'm looking for is, I want every day in July to be 450, and every day in August to be 500 (as examples). Then I want to sum it up to today. I have tried (Labelled Monthly Average):
IF MONTH([Date])=7 and YEAR([Date]) = 2025 then '450'
ELSEIF MONTH([Date])=8 and YEAR([Date]) = 2025 then '500'
ELSE NULL
END
But, it does not give me the correct number when I then do a formula that goes:
IF [Date] < TODAY() THEN
([Monthly Average)
END
Is there a way to do this? Basically I have an average per day, that changes each month, and I want it to sum up to today.
Only other real option here is makeup some dates using MAKEDATE() function, then calculate the number of days between each 'month' to today. A number of calc's involved in the attached, but it gets you an aggregated real value:
So, maybe it'll point the way for what it is you're trying for on your end. New workbook attached. BTW the running sum numbers for the Superstore data will be off in terms of number of actual days of the month as that dataset traditionally doesn't have all days in a particular month.
E.g., August 2 and August 9 are not in the Superstore data set. Which is why there's a difference between this post and my prior post. The above accounts for all days in the month.
Best, Don Wise -
Please don’t forget to upvote and/or Select as Best by clicking the hyperlink below in the response that answered your question.
