View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Adding 4 business days to a specified date

Hi LLSherry

You can use the Workday function
If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"LLSherry" wrote in message ...
hello

I am hoping someone can help me put a function into my worksheet when using dates.
I have two columns one is start date and I need to calculate an end date in the second column that is plus 4 business days.

Can anyone tell me if there is a formula for this? I have checked my excel bible and found the networkdays function but this
seems to give the number of business days between a specified start date and a specified stop date.

Thanks all!!!!!!!!!