Determine Work Days Between Dates

Home Forums Cool Tricks Determine Work Days Between Dates

Viewing 0 reply threads
  • Author
    Posts
    • #973
      Neil Parsont
      Keymaster
      Cool Trick: Determine Work Days Between Dates
      
      Question: How many working business days from one date to the next?
      
      Answer: NETWORKDAYS function tells us the work days between a start date and end date. It even takes out holiday dates! 
      Just select the start date, end date, and optionally include holidays and Excel does the rest. 
      
      NetworkDays
      Attachments:
Viewing 0 reply threads
  • You must be logged in to reply to this topic.