![]() |
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) |
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