ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding 4 business days to a specified date (https://www.excelbanter.com/excel-programming/291092-re-adding-4-business-days-specified-date.html)

Ron de Bruin

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!!!!!!!!!





All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com