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()))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top