Determine Date After X Work Days

Home Forums Cool Tricks Determine Date After X Work Days

This topic contains 0 replies, has 1 voice, and was last updated by Avatar Neil Parsont 5 years, 7 months ago.

  • Author
  • #975
    Neil Parsont
    Cool Trick: Determine Date After X Work Days
    Question: What is the expected completion date if a project starts on Jan 1st 2016 and is expected to take 60 working days to finish?
    Answer: The WORKDAY uses a start date, work days and optional holidays to calculate the expected completion date. Unfortunately, the 
    default result is formatted as a serial number...
    Hint: Change the cell format to Date

You must be logged in to reply to this topic.