Forum Discussion

DKoontz's avatar
DKoontz
Iron Contributor
Mar 11, 2021
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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 11, 2021

    DKoontz 

    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()
)
Tomsleepzonecojp's avatar
Tomsleepzonecojp
Copper Contributor
Jun 23, 2021
I've got a question about an =If calculation.

DKoontz's avatar
DKoontz
Iron Contributor
Jun 23, 2021
What's your question? I might be able to offer some help!

Resources