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

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

Find more posts tagged with

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.