Counting how many sales were made this week, starting the count from Monday

Joyce Ghali

Hi!

I would like to count number of sales , depending on the date that the sale was made. Also the week should update every week, and I've found this formula: =COUNTIF({Sales Data}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY())),

and it works, but is there something else I could add to it so that it will start counting the sales starting from Monday instead of Sunday?

Thank you

Mark Cronk

Hi Joyce,

Weeknumber starts numbering on Mondays already.

https://help.smartsheet.com/function/weeknumber

Why do you think it's starting on Sunday?

Mark

Mark Cronk

Hi Joyce,

Weeknumber starts numbering on Mondays already.

https://help.smartsheet.com/function/weeknumber

Why do you think it's starting on Sunday?

Mark

Joyce Ghali

The numbers I was getting were off! I thought it was counting starting Sunday

Mark Cronk

Hi Joyce,

If you share a screenshot of your sheet and formula I'll try to figure out what's causing the problem.

Mark