Discussions

Expand all | Collapse all

Date Formula

  • 1.  Date Formula

    Posted 08-31-2018 13:19
    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


  • 2.  RE: Date Formula

    Posted 08-31-2018 13:22
    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.


  • 3.  RE: Date Formula

    Posted 08-31-2018 13:47
    Hi 

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




  • 4.  RE: Date Formula

    Posted 08-31-2018 15:15
    thanks for the help.