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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

Heather Duff

Hi!

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.