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 4 years, 6 months ago.

  • Author
    Posts
  • #975
    Avatar
    Neil Parsont
    Keymaster
    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
    
    WorkDays
    Attachments:

You must be logged in to reply to this topic.