Hi is there anyway to count how many Sat,Sun Between two dates we are working
on a training prog and training only takes place durring the week and not
weekends.
I need to count the number of days Thanks for any help.
Frank

You could do a simple sub traction of 1 from the other, this gives you the
number of days, and then subtract the NETWORKDAYS from it. For instance, the
tow dates in A1 and A2

= (A2-A1) - NETWORKDAYS(A1,A2)+1


--
HTH

Bob Phillips

"Frank" wrote in message
...
Hi is there anyway to count how many Sat,Sun Between two dates we are
working
on a training prog and training only takes place durring the week and not
weekends.
I need to count the number of days Thanks for any help.
Frank

Just to add/perhaps clarify,

While the OP asked for number of Sat & Sun, I think they actually want the
number of workdays between two dates, so NetWorkdays alone should do the
job.

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote in message
...
You could do a simple sub traction of 1 from the other, this gives you the
number of days, and then subtract the NETWORKDAYS from it. For instance,
the
tow dates in A1 and A2

= (A2-A1) - NETWORKDAYS(A1,A2)+1


--
HTH

Bob Phillips

"Frank" wrote in message
...
Hi is there anyway to count how many Sat,Sun Between two dates we are
working
on a training prog and training only takes place durring the week and
not
weekends.
I need to count the number of days Thanks for any help.
Frank