| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Project future date w/ 6 day work week and holiday
How can I calculate a future date based on a start date, taking in
consideration holidays? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Project future date w/ 6 day work week and holiday
Assuming a 6 day week
"damucol" wrote: How can I calculate a future date based on a start date, taking in consideration holidays? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Project future date w/ 6 day work week and holiday
I assume you count Sunday as the only non-workday
Assuming start date in A2, workdays to add in B2, list of holiday dates defined as named range holidays =A2+SMALL(IF((WEEKDAY(A2+ROW(INDIRECT("1:"&B2*10)) )1)*ISNA(MATCH(A2+ROW(INDIRECT("1:"&B2*10)),holid ays,0)),ROW(INDIRECT("1:"&B2*10))),B2) confirmed with CTRL+SHIFT+ENTER format as date "damucol" wrote: Assuming a 6 day week "damucol" wrote: How can I calculate a future date based on a start date, taking in consideration holidays? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Project future date w/ 6 day work week and holiday
It did not work! The result is #NUM on the cell. What am I doing wrong?
The cell is formated as date. what kind of confirmation is required for CTRL+SHIFT+ENTER? I have the list of holidays on a spreadsheet that I am calling Holidays and the dates are located between cells B9:B30. "daddylonglegs" wrote: I assume you count Sunday as the only non-workday Assuming start date in A2, workdays to add in B2, list of holiday dates defined as named range holidays =A2+SMALL(IF((WEEKDAY(A2+ROW(INDIRECT("1:"&B2*10)) )1)*ISNA(MATCH(A2+ROW(INDIRECT("1:"&B2*10)),holid ays,0)),ROW(INDIRECT("1:"&B2*10))),B2) confirmed with CTRL+SHIFT+ENTER format as date "damucol" wrote: Assuming a 6 day week "damucol" wrote: How can I calculate a future date based on a start date, taking in consideration holidays? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for a 4 day work week | Excel Worksheet Functions | |||
| how to count easily | Excel Worksheet Functions | |||
| How do I set up a 6 day work week in Excel? | Excel Worksheet Functions | |||
| Work week holiday for different countries | Charts and Charting in Excel | |||
| how to set a 6-day work week ? | Excel Worksheet Functions | |||
Linear Mode
