# 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

• ✭✭✭✭✭✭

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:

• ✭✭✭✭✭✭

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:

• Perfection! Thank you so much!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!