Forum Discussion
Solved
Week to Date Calculation off of Specific Date
Hi Everyone! I'm trying to calculate WTD sales off of the current date and can't seem to come up with a great solution. So far I'm thinking calculating Weekday() starting on Monday and using that...
It's hard to discuss without sample file which illustrates how your data is organized. As variant
=SUMIFS(Sales!C:C, Sales!B:B,">"&TODAY()-WEEKDAY(TODAY(),11), Sales!B:B,"<"&TODAY() )
This is almost works, and is so much more concise! But if we are in the middle of the month, the formula needs to exclude older dates and only take the current week. That's kind of what I was thinking with starting from weekday() so I could always add from the latest Monday onward. I just read up more on using </>/= operators in the formulas like that and that's a huge help, I wasn't aware of that feature before, I'll try again some more using these. Thank you!
It's hard to discuss without sample file which illustrates how your data is organized. As variant
=SUMIFS(Sales!C:C, Sales!B:B,">"&TODAY()-WEEKDAY(TODAY(),11), Sales!B:B,"<"&TODAY() )- This is perfect! I changed the last "<" to "<=" and its working perfectly. Thank you so much, I've been looking for a solution for so long.
DKoontz you are welcome, glad it helped