Date Formula

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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
Photo of Anthony Butcher

Anthony Butcher

  • 110 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
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.
Photo of Aroof Rahaman Shaik

Aroof Rahaman Shaik

  • 152 Points 100 badge 2x thumb
Hi 

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


Photo of Anthony Butcher

Anthony Butcher

  • 110 Points 100 badge 2x thumb
thanks for the help.