Forum Discussion

AnthonyButcher's avatar
AnthonyButcher
Qrew Trainee
6 years ago

Date Formula

i'm trying to create a formula that shows how many days left until due date
how would i write the below formula
eg 

Start date            Go live date        Days left 
01/01/2018          01/15/2018            14

3 Replies

  • SuryaExpert's avatar
    SuryaExpert
    Qrew Assistant Captain
    I would create a formula duration field for Days Left and the formula would be [Go Live Date]-[Start Date]. You can have a choice of the units but leaving it at the default "Smart Units" is probably the best. Hope that helps.
  • Hi 

    You can use WeekdayAdd( date ,  week days )Weekenddays option  to finding  duration or target 
    date .