Help

How to show a "weeks until" master date?

1297 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Appenzell
5 - Automation Enthusiast
5 - Automation Enthusiast

I am making a project timeline and I would like to have a function tell me how many weeks out a task is due in relation to a final project date. For example, the event is December 15th. If I added a task due October 15th, the formula would say 8 weeks out.

3 Replies 3

You’ve got DATETIME_DIFF() function:

Kelly_Appenzell
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes, but when I try to put in the master date it returns incorrect values. For example.

DATETIME_DIFF({Start Date},04-05-2019,‘weeks’)

How do I use the master date of 04-05-2019

Nevermind - I figured it out with a work around. I made a Fx field = “04/05/2019” so it auto-filled. Then I hid that column. But the wrote the formula as a to,from that auto-filled date .