View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Finding WKends Between two Dates

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