Date Diff

S

SageOne

Is there a function that calculates the date diff between two dates but
discounts weekends?

Basically I need to calculate the business day date diff.
 
S

Steve

Your post does not mention it but do you want to discount holidays too?

Steve
(e-mail address removed)
 
S

SageOne

Found that code.....that for you help guys......Yes, I would like to also
exclude holidays....is there a way to specify the holidays? Some holidays
are not observed for the purposes of my report.
 
J

John W. Vinson

Found that code.....that for you help guys......Yes, I would like to also
exclude holidays....is there a way to specify the holidays? Some holidays
are not observed for the purposes of my report.

And of course different companies and countries celebrate different holidays.
The typical solution is to have a Holidays table with one record for each
holiday date. Check the websites again, most published solutions have a
Holidays table and use it in the calculation.
 

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

Top