| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates not including weekends and holidays
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill weekends and holidays | Excel Worksheet Functions | |||
| excel total days formula including weekends, excluding holidays | Excel Discussion (Misc queries) | |||
| Days between dates including start day and weekends | Excel Worksheet Functions | |||
| time interval between dates incl weekends excl holidays | Excel Discussion (Misc queries) | |||
| Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) | |||
Linear Mode
