Determine Work Days Between Dates

Home Forums Cool Tricks Determine Work Days Between Dates

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

  • Author
    Posts
  • #973
    Avatar
    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:

You must be logged in to reply to this topic.