Has the ability to state a type (start day) in WEEKNUMBER been removed

RichardJ

I had this formula which generated a week number with the start date being Friday due to the type being '15'

=IF(Date@row <> "", WEEKNUMBER(Date@row, 15), "")

which used to work.

Now the type within the function seems to be ignored.

Has the ability to specify a week start date within the WEEKNUMBER function been removed

Thanks

Find more posts tagged with

first day of week

Accepted answers

Genevieve P.

Hey @RichardJ

It sounds like you may be referring to an Excel function. Smartsheet's WEEKNUMBER Function does not have the ability to add in a "type" to adjust when the week starts. Smartsheet calculates week numbers based on Mondays.

Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!

In the meantime, how I personally adjust this is by using the WEEKDAY function as well. I my sheets, my work week starts on a Sunday, so I've adjusted the formula like so:

=IF(WEEKDAY(Date@row) = 1, WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))

If your week starts on a Friday, you could do something similar:

=IF(OR(WEEKDAY(Date@row) = 1, WEEKDAY(Date@row) >= 6), WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))

Cheers,

Genevieve

All comments

Genevieve P.

Hey @RichardJ

In the meantime, how I personally adjust this is by using the WEEKDAY function as well. I my sheets, my work week starts on a Sunday, so I've adjusted the formula like so:

=IF(WEEKDAY(Date@row) = 1, WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))

If your week starts on a Friday, you could do something similar:

=IF(OR(WEEKDAY(Date@row) = 1, WEEKDAY(Date@row) >= 6), WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Date@row))

Cheers,

Genevieve

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.