Weeks to Project Due

ABice Norton

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

Debbie Sawyer

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:

Debbie Sawyer

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:

ABice Norton

Perfection! Thank you so much!