Date

1. Senior Member
Join Date
Dec 1969
Posts
451

## Date

I am curious if someone knows of a way I can input a date range say like:<BR><BR>05/01/2004 .... 05/13/2004 and it would calculate how many work days are in this span....<BR><BR>Any suggestions?

2. Senior Member
Join Date
Dec 1969
Posts
11,247

## OOOW tough one!

DateDiff()

3. Senior Member
Join Date
Dec 1969
Posts
451

## No?

I am not trying to find the difference between the two dates, well actually I am but I need to minus out saturdays and sundays and was wondering if there was an easdy way of doing this...

4. Senior Member
Join Date
Dec 1969
Posts
11,334

## Holidays to?

You&#039;ll have to get an array of holidays if so...<BR><BR>but for just sat and sun, just check the thingy before you enter it:<BR><BR>if (myday = vbSaturday or myday = vbSunday) then<BR> &#039;don&#039;t calculate me

5. Senior Member
Join Date
Dec 1969
Posts
451

## RE: Holidays to?

6. Senior Member
Join Date
Dec 1969
Location
Los Angeles, CA
Posts
21,192

## To??

why to....why not two...sometimes a three but i think more like a too<BR><BR>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•