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.
|