View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angelo1803 Angelo1803 is offline
external usenet poster
 
Posts: 1
Default how can i networkdays date ranges where dates overlap

I have a list of date ranges, start dates to finish dates, they overlap and
sometimes there are date gaps in between.
My question is how do i find out the network days.

example:
Start Date End date ...... start date end date..... start date end date
4/2/08 5/2/08 4/2/08 6/2/08 7/2/08 8/2/08

the dates are in rows and not columns so i need a formula to tell me total
networkdays between all them days.