Skip to main content
Question

Date Formula

  • August 31, 2018
  • 0 replies
  • 90 views
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
    This topic has been closed for replies.

    • SuryaExpert
    • Registered
    • August 31, 2018
    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.
    • AroofShaik
    • Registered
    • August 31, 2018
    Hi 

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


    • AnthonyButcher
    • Author
    • Registered
    • August 31, 2018
    thanks for the help.
    Terms & ConditionsAccessibility statement