Thread: Dates not including weekends and holidays
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Dates not including weekends and holidays
Hi

Look at the ATP function

Networkdays

NETWORKDAYS(start_date,end_date,holidays)





--
Regards Ron de Bruin
http://www.rondebruin.nl


"WNB-96740" wrote in message ...
Column A1 is start date
Column B1 is ending date which is 5 days after the start date not counting
Sat. and Sun. and a Holiday.

How can I do the formula in B1?

Thank you!


Reply With QuoteReply With Quote