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

Best Answer

  • Ramzi
    Ramzi ✭✭✭✭✭
    Answer ✓

    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

    Smartsheet Solutions Architect

    www.adapture.com

Answers

  • Ramzi
    Ramzi ✭✭✭✭✭
    Answer ✓

    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

    Smartsheet Solutions Architect

    www.adapture.com