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


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!