ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add no. of days to a workday to get new workday? (https://www.excelbanter.com/excel-worksheet-functions/261609-add-no-days-workday-get-new-workday.html)

blswes

Add no. of days to a workday to get new workday?
 
Looking for a formula so I can add a number of workdays to an existing date
to get the new workday (i.e. existing date + workdays = new workday).

Here's an example:
1) Starting point: 4/15/10
2) Add: 4
3) Result: 4/21/10 (because it's 4 workdays after start date -- skipped
weekend)

Duke Carey

Add no. of days to a workday to get new workday?
 
Look in Help for details on the WORKDAY() function

"blswes" wrote:

Looking for a formula so I can add a number of workdays to an existing date
to get the new workday (i.e. existing date + workdays = new workday).

Here's an example:
1) Starting point: 4/15/10
2) Add: 4
3) Result: 4/21/10 (because it's 4 workdays after start date -- skipped
weekend)



All times are GMT +1. The time now is 12:42 PM.

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