Determine Date After X Work Days

Home › Forums › Cool Tricks › Determine Date After X Work Days

Viewing 0 reply threads
  • Author
    Posts
    • January 22, 2016 at 6:56 PM #975
      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:

      1. FB-Excel-1.png

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.