Weeks to Date Formula- Revision Needed

ABice Norton

Hi All,

I am currently using the following formula to calculate the weeks until my project delivery date.

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

We deliver the project on Tuesday and count that week as week 0.

How can I modify this formula so that it reflects the final week as week zero as opposed to the week prior?

Any help is greatly appreciated

Heather Duff

Hi!

This may be waaaaay too elementary of an answer...but is it maybe as simple as just doing a +1 at the end of the formula? If the week prior to the due date week is showing as 0, then you could just add 1 to make the final week show as 0. Does that make sense?

Best,

Heather

Heather Duff

You're welcome! I'm glad it helped - and I'm glad it was a simple answer! Have a great weekend.

Heather Duff

Hi!

This may be waaaaay too elementary of an answer...but is it maybe as simple as just doing a +1 at the end of the formula? If the week prior to the due date week is showing as 0, then you could just add 1 to make the final week show as 0. Does that make sense?

Best,

Heather

ABice Norton

Heather, THANK YOU! I knew it was something as simple as that and just couldn't gather it together after such a long day. Thank you again!!

Heather Duff

You're welcome! I'm glad it helped - and I'm glad it was a simple answer! Have a great weekend.