Consecutive date calculation involving holidays
I know that you can figure out a date using the WORKDAY function, but how do
you figure out a date for just consecutive days. I basically want to add days to an initial date while keeping a list of holidays in mind. A B 1 11/01/09 I want column B to add 50 days to column A while keeping track of the holiday list. This is the formula I use for the Workdays: =WORKDAY(A1,50,$J$1376:$J$1390) Thanks! |
Consecutive date calculation involving holidays
On Thu, 12 Nov 2009 13:39:01 -0800, BMoran
wrote: I know that you can figure out a date using the WORKDAY function, but how do you figure out a date for just consecutive days. I basically want to add days to an initial date while keeping a list of holidays in mind. A B 1 11/01/09 I want column B to add 50 days to column A while keeping track of the holiday list. This is the formula I use for the Workdays: =WORKDAY(A1,50,$J$1376:$J$1390) Thanks! If you look at HELP for the WORKDAY function, you will see how to use the optional HOLIDAYS argument. --ron |
All times are GMT +1. The time now is 09:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com