Workdays

  • Thread starter Thread starter John Flynn
  • Start date Start date
J

John Flynn

I am using Days360 function within Excel to extract the
number of days that an item is open. However, the purist
in me would like to exclude weekends and holidays so that
we have a true workdays open calculation.

Thanks
 
John,

Use the NETWORKDAYS to determine the number of weekdays between two dates.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
See the Excel help for the NETWORKDAYS and the WORKDAY function

If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
 
Back
Top