Weeks to Date Formula Revision Needed
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
Best Answers

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

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

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, 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!!

You're welcome! I'm glad it helped  and I'm glad it was a simple answer! Have a great weekend.
Help Article Resources
Categories
Check out the Formula Handbook template!