Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

Function to return work days from date range

I'm looking for a function that will return just work days (M-F) from a date range.  I would pass it a begining date and an end date and it would return a count of work days.  I need this for a VBA function that I am writing to find out how close people are when they estimate a project length.  I do have Total Visual Sourcebook but haven't used it yet (in case they have it).
0
schmir1
Asked:
schmir1
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
0
 
97WideGlideCommented:
0
 
schmir1Author Commented:
Capricorn1

Thanks.  Your function is short and sweet and worked right out of the box.  I also liked the fact that it can count holidays also.  
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now