Weeks to Project Due


Hi All,

I am looking for a very simple formula to help me return the following:

The product due date is 10/17/21, week 0, and I would like to create a formula to tell me what working week we are currently in today.

I am able

Any help is greatly appreciated

Best Answer

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    edited 01/29/21 Answer ✓

    Can you work out the number of days between the Product Due date and Today and divide the answer by 7? (take the Integer result) - would that work?

    =INT(([Product Due Date]@row - Today())/7)

    Any good?

    Or if you wanted the week numbers to show in negative then swap the subtraction around like this:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!