| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use placeholders for constanst array using workday function?
Hello,
I would appreciate your help with: Trying to create an automated process whe A is Date; B is days; C returns date (where referenced to constant array) Array would consist of 9 holidays, but I would like to include up to 25 place holders in order to activate on main worksheet with checkbox to turn "on" Like this: A B Holiday; 1/1/09 Holiday; 2/16/09 Holiday; 5/25/09 etc (total of 9) Reserved 1; empty Reserved 2; empty Reserved 3; empty Reserved 4; empty etc (up to 25 reserved) I appreciate your help. Thanks -- - thank you penGuin_1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use placeholders for constanst array using workday function?
Why don't you just use a dynamic range for the holidays list?
-- Biff Microsoft Excel MVP "penGuin_1" wrote in message ... Hello, I would appreciate your help with: Trying to create an automated process whe A is Date; B is days; C returns date (where referenced to constant array) Array would consist of 9 holidays, but I would like to include up to 25 place holders in order to activate on main worksheet with checkbox to turn "on" Like this: A B Holiday; 1/1/09 Holiday; 2/16/09 Holiday; 5/25/09 etc (total of 9) Reserved 1; empty Reserved 2; empty Reserved 3; empty Reserved 4; empty etc (up to 25 reserved) I appreciate your help. Thanks -- - thank you penGuin_1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use placeholders for constanst array using workday funct
Thank you for your quick response - though I am not sure what you are
referring to with a dynamic range -- - thank you penGuin_1 "T. Valko" wrote: Why don't you just use a dynamic range for the holidays list? -- Biff Microsoft Excel MVP "penGuin_1" wrote in message ... Hello, I would appreciate your help with: Trying to create an automated process whe A is Date; B is days; C returns date (where referenced to constant array) Array would consist of 9 holidays, but I would like to include up to 25 place holders in order to activate on main worksheet with checkbox to turn "on" Like this: A B Holiday; 1/1/09 Holiday; 2/16/09 Holiday; 5/25/09 etc (total of 9) Reserved 1; empty Reserved 2; empty Reserved 3; empty Reserved 4; empty etc (up to 25 reserved) I appreciate your help. Thanks -- - thank you penGuin_1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use placeholders for constanst array using workday funct
I don't understand what you're trying to do, but...
Debra Dalgleish explains dynamic range names he http://contextures.com/xlNames01.html#Dynamic penGuin_1 wrote: Thank you for your quick response - though I am not sure what you are referring to with a dynamic range -- - thank you penGuin_1 "T. Valko" wrote: Why don't you just use a dynamic range for the holidays list? -- Biff Microsoft Excel MVP "penGuin_1" wrote in message ... Hello, I would appreciate your help with: Trying to create an automated process whe A is Date; B is days; C returns date (where referenced to constant array) Array would consist of 9 holidays, but I would like to include up to 25 place holders in order to activate on main worksheet with checkbox to turn "on" Like this: A B Holiday; 1/1/09 Holiday; 2/16/09 Holiday; 5/25/09 etc (total of 9) Reserved 1; empty Reserved 2; empty Reserved 3; empty Reserved 4; empty etc (up to 25 reserved) I appreciate your help. Thanks -- - thank you penGuin_1 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use placeholders for constanst array using workday funct
Thanks Dave - I will give that a try and see if it works
-- - thank you penGuin_1 "Dave Peterson" wrote: I don't understand what you're trying to do, but... Debra Dalgleish explains dynamic range names he http://contextures.com/xlNames01.html#Dynamic penGuin_1 wrote: Thank you for your quick response - though I am not sure what you are referring to with a dynamic range -- - thank you penGuin_1 "T. Valko" wrote: Why don't you just use a dynamic range for the holidays list? -- Biff Microsoft Excel MVP "penGuin_1" wrote in message ... Hello, I would appreciate your help with: Trying to create an automated process whe A is Date; B is days; C returns date (where referenced to constant array) Array would consist of 9 holidays, but I would like to include up to 25 place holders in order to activate on main worksheet with checkbox to turn "on" Like this: A B Holiday; 1/1/09 Holiday; 2/16/09 Holiday; 5/25/09 etc (total of 9) Reserved 1; empty Reserved 2; empty Reserved 3; empty Reserved 4; empty etc (up to 25 reserved) I appreciate your help. Thanks -- - thank you penGuin_1 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using WORKDAY function | Excel Discussion (Misc queries) | |||
| Using WORKDAY function | Excel Worksheet Functions | |||
| Workday function | Excel Discussion (Misc queries) | |||
| Workday function | Excel Worksheet Functions | |||
| How do I get the WORKDAY function? | Excel Discussion (Misc queries) | |||
Linear Mode
