Thread: Networkdays
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Networkdays

1 way

=NETWORKDAYS(A10,A11,B8:B40)

where
a10 start date
a11 end date
B8:B40 every friday between those 2 dates (Easy to create with autofill)

Mike


"Dave" wrote:

I know the networkdays automatically calculates the monday to friday
routine between two dates. How can I howether compare two dates that
doesn't count friday as a workday also, as well as the normal saturday
and sunday?