Need the number of working Days between 2 dates

D

David Busby

Using VB in MSP I need to determine the number of working days between two
dates. I can used DateDiff but that picks up non-working days as well. Can
anyone tell me an easy way to be able to pass in two dates and determine the
number of working dates between them.
 
J

John

David Busby said:
Using VB in MSP I need to determine the number of working days between two
dates. I can used DateDiff but that picks up non-working days as well. Can
anyone tell me an easy way to be able to pass in two dates and determine the
number of working dates between them.
Click to expand...

David,
What you want is the DateDifference Method, if you are using VBA. Just
remember that the value returned will be in minutes. The DateDiff
Function will give you the number of calendar days (or whatever other
interval you set) between two dates.

John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inconsistent formatting of section numbers 0
Changing Baseline dates due to snow days 0
Goal Seeking via Excel 0
Space at end of multi page list to accommodate new entries 1
number of months and days between two dates without approximation 3
Menu Macro Not Executing - Need Help 1
Page numbering with Merged Document and IF statements 1
Expanding Date Formula 0

Top