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()))
 
You must log in or register to reply here.

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

Similar Threads

@IF Formula 3
NETWORKDAYS 2
networkdays alternative 2
Calculating three working days before a date 4
networkdays 5
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
IF(AND) with NETWORKDAYS 2
NETWORKDAYS Formula 1

Back
Top