View Single Post
 
Old 03-25-2014, 07:34 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Use NETWORKDAYS(start,end,[holidays])

[holidays] is an optional range of holidays to exclude.

The equation returns the number of days between the dates inclusive of the dates so for your dates, the function returns 5 (without accounting for holidays).
Reply With Quote