ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding workdays (https://www.excelbanter.com/excel-worksheet-functions/174999-adding-workdays.html)

Excel-learner

Adding workdays
 
I need to add networkdays to a date that will return a date
(example: start date 1/1/08 plus 10 networkdays = 1/15/08 because 1/1/08 is
a holiday and 4 days are weekends).

Teethless mama

Adding workdays
 
=WORKDAY(start_date,duration,holidays)


"Excel-learner" wrote:

I need to add networkdays to a date that will return a date
(example: start date 1/1/08 plus 10 networkdays = 1/15/08 because 1/1/08 is
a holiday and 4 days are weekends).



All times are GMT +1. The time now is 05:27 PM.

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