Count weeks in a Cycle

TolerDo

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

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

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!