Count weeks in a Cycle

I know there is a function for counting weeks based on the start of the year.

Is it possible to count weeks from a specific start date, instead of from January 1?

For example, I might have 12 weeks in a cycle of a project, and would like to show (on a dashboard) that we are in "week # of 12 weeks" in a specific cycle.

Appreciate the help as always!

Thanks,

Donna

Find more posts tagged with

functionality

Time Calculation

Accepted answers

Ramzi

Here's one way to do it:

In this example, I have two columns

Cycle Start is a Date column with the date of the start of your 12 week cycle.

Week In Cycle gives you the number of weeks into the cycle based on TODAY.

The formula in Week In Cycle column: =WEEKNUMBER(TODAY()) - WEEKNUMBER([Cycle Start]@row)

I hope this helps you.

Cheers,

Ramzi

Smartsheet Solution Architect

www.adapture.com

Platinum Partner

All comments

Ramzi

Here's one way to do it:

In this example, I have two columns

Cycle Start is a Date column with the date of the start of your 12 week cycle.

Week In Cycle gives you the number of weeks into the cycle based on TODAY.

The formula in Week In Cycle column: =WEEKNUMBER(TODAY()) - WEEKNUMBER([Cycle Start]@row)

I hope this helps you.

Cheers,

Ramzi

Smartsheet Solution Architect

www.adapture.com

Platinum Partner

TolerDo

Thank you!

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.