Non working days
Also no need to use DateDif, just B1-A1
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Mike" wrote in message
...
Sorry, I should have added that because you want 'between' 2 dates the
earlier date must be moved 1 day back. i.e. in this example 31/12/2006.
Mike
"The Rook" wrote:
Is there a formula to calculate the number of non working days between 2
specific dates. For example:
01-01-07 to 31-01-07
No. of Saturdays = 4
No. of Sundays = 4
Cheers
|