Diff2Dates Calculation without Weekends or Holidays

M

Matt

Is there a way for the Diff2Dates function to exclude weekends and holidays
in its calculation of the Difference between to General Dates?

For Example:
A field in my reporthas the following control source:
=Diff2Dates("dhn",[DateRcvd],[DateDue],True)

Where DateRcvd= 7/14/2008 08:00am and DateDue=7/21/2008 2:00pm

Right now the Diff2Dates function returns 7days 6hrs 0mins, and it should
return 5days 6hrs 0mins.

What code should be entered in my module to do this? I understand I will
probably have to build a table called tbl_Holidays with a HolidayDate Field.
 

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

Steele's Diff2Dates Function without Holidays & Weekends 4
Infamous Business Day Count 7
Subtract day and time w/o weekends or holidays 2
identifying the next working day after weekends and/or holidays 2
Future date with six day week including holidays 1
Production date/time/weekends 0
Dates calculation should consider holidays and weekends to suggest 4
Calculation of end date 4

Top