dates & lists

  • Thread starter Thread starter emmjaybee
  • Start date Start date
E

emmjaybee

Thanks for help re above.

Is there any way of incorporating - NETWORKDAYS into the
formulas suggested and obtaining similar lists??
 
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()))
 
Back
Top