View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Finding WKends Between two Dates

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