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

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:
Answers

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
Categories
Check out the Formula Handbook template!