dates & lists

E

emmjaybee

Thanks for help re above.

Is there any way of incorporating - NETWORKDAYS into the
formulas suggested and obtaining similar lists??
 
A

Arvi Laanemets

Hi

I can't imagine, what you want to do with NETWORDAYS function here. But when
you want to list only working days, then the formula (the second one, with
start and end dates in B1:B2) will be now:

=IF(WORKDAY(B$1+1,-ROW())<B$2,"",WORKDAY(B$1+1,-ROW()))
 
Top