# 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

• ✭✭✭✭✭

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

Platinum Partner

Smartsheet Solutions Architect

• ✭✭✭✭✭

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