| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays formula in macro
Hi:
I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)" replacing I2 with ActiveCell.Offset(0,-9) and O2 with (ActiveCell.Offset(0,-3). My string below gives me the error #NAME? ActiveCell = "=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))" Could anyone help me please. Thanks, Orquidea |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Networkdays formula in macro
maybe...
ActiveCell.formula = "=NETWORKDAYS(" & ActiveCell.Offset(0, -9).Address(0, 0) _ & "," & ActiveCell.Offset(0, -3).Address(0, 0) & ")" orquidea wrote: Hi: I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)" replacing I2 with ActiveCell.Offset(0,-9) and O2 with (ActiveCell.Offset(0,-3). My string below gives me the error #NAME? ActiveCell = "=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))" Could anyone help me please. Thanks, Orquidea -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Networkdays formula in macro
Hi,
I'm not sure what values you intend to put in these 2 offset cells but try this ActiveCell = "=NETWORKDAYS(" & ActiveCell.Offset(0, -9).Value & "," & ActiveCell.Offset(0, -3).Value & ")" The answer has line-wrapped Mike "orquidea" wrote: Hi: I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)" replacing I2 with ActiveCell.Offset(0,-9) and O2 with (ActiveCell.Offset(0,-3). My string below gives me the error #NAME? ActiveCell = "=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))" Could anyone help me please. Thanks, Orquidea |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Networkdays formula in macro
Thanks Mike:
I tried your string but it gives me result 0. I2 (ActiveCell.Offset(0,-9) = 05/30/08 and O2(ActiveCell.Offset(0,-3)= 06/02/08. The result I should get is 2. Orquidea "Mike H" wrote: Hi, I'm not sure what values you intend to put in these 2 offset cells but try this ActiveCell = "=NETWORKDAYS(" & ActiveCell.Offset(0, -9).Value & "," & ActiveCell.Offset(0, -3).Value & ")" The answer has line-wrapped Mike "orquidea" wrote: Hi: I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)" replacing I2 with ActiveCell.Offset(0,-9) and O2 with (ActiveCell.Offset(0,-3). My string below gives me the error #NAME? ActiveCell = "=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))" Could anyone help me please. Thanks, Orquidea |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Networkdays formula in macro
Hi,
The formula I gave you works fine if the offset cells contain cell references but you never said what you were using. This works for dates in those cells. Note the additional quotes. ActiveCell = "=NETWORKDAYS(""" & ActiveCell.Offset(0, -9) & """,""" & ActiveCell.Offset(0, -3) & """)" Mike "orquidea" wrote: Thanks Mike: I tried your string but it gives me result 0. I2 (ActiveCell.Offset(0,-9) = 05/30/08 and O2(ActiveCell.Offset(0,-3)= 06/02/08. The result I should get is 2. Orquidea "Mike H" wrote: Hi, I'm not sure what values you intend to put in these 2 offset cells but try this ActiveCell = "=NETWORKDAYS(" & ActiveCell.Offset(0, -9).Value & "," & ActiveCell.Offset(0, -3).Value & ")" The answer has line-wrapped Mike "orquidea" wrote: Hi: I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)" replacing I2 with ActiveCell.Offset(0,-9) and O2 with (ActiveCell.Offset(0,-3). My string below gives me the error #NAME? ActiveCell = "=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))" Could anyone help me please. Thanks, Orquidea |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Networkdays formula in macro
My mistake, I assumed that NETWORKDAYS just workes with dates, I guess not.
Thanks, It works now. "Mike H" wrote: Hi, The formula I gave you works fine if the offset cells contain cell references but you never said what you were using. This works for dates in those cells. Note the additional quotes. ActiveCell = "=NETWORKDAYS(""" & ActiveCell.Offset(0, -9) & """,""" & ActiveCell.Offset(0, -3) & """)" Mike "orquidea" wrote: Thanks Mike: I tried your string but it gives me result 0. I2 (ActiveCell.Offset(0,-9) = 05/30/08 and O2(ActiveCell.Offset(0,-3)= 06/02/08. The result I should get is 2. Orquidea "Mike H" wrote: Hi, I'm not sure what values you intend to put in these 2 offset cells but try this ActiveCell = "=NETWORKDAYS(" & ActiveCell.Offset(0, -9).Value & "," & ActiveCell.Offset(0, -3).Value & ")" The answer has line-wrapped Mike "orquidea" wrote: Hi: I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)" replacing I2 with ActiveCell.Offset(0,-9) and O2 with (ActiveCell.Offset(0,-3). My string below gives me the error #NAME? ActiveCell = "=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))" Could anyone help me please. Thanks, Orquidea |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Networkdays formula in macro
Hi,
Networkdays works with dates directly or with cell references that refer to dates but if using dates directly extra quotes are needed. Thanks for the feedback. Mike "orquidea" wrote: My mistake, I assumed that NETWORKDAYS just workes with dates, I guess not. Thanks, It works now. "Mike H" wrote: Hi, The formula I gave you works fine if the offset cells contain cell references but you never said what you were using. This works for dates in those cells. Note the additional quotes. ActiveCell = "=NETWORKDAYS(""" & ActiveCell.Offset(0, -9) & """,""" & ActiveCell.Offset(0, -3) & """)" Mike "orquidea" wrote: Thanks Mike: I tried your string but it gives me result 0. I2 (ActiveCell.Offset(0,-9) = 05/30/08 and O2(ActiveCell.Offset(0,-3)= 06/02/08. The result I should get is 2. Orquidea "Mike H" wrote: Hi, I'm not sure what values you intend to put in these 2 offset cells but try this ActiveCell = "=NETWORKDAYS(" & ActiveCell.Offset(0, -9).Value & "," & ActiveCell.Offset(0, -3).Value & ")" The answer has line-wrapped Mike "orquidea" wrote: Hi: I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)" replacing I2 with ActiveCell.Offset(0,-9) and O2 with (ActiveCell.Offset(0,-3). My string below gives me the error #NAME? ActiveCell = "=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))" Could anyone help me please. Thanks, Orquidea |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NETWORKDAYS formula | Excel Discussion (Misc queries) | |||
| need help with networkdays formula | Excel Worksheet Functions | |||
| Networkdays formula | Excel Worksheet Functions | |||
| NETWORKDAYS FORMULA | Excel Worksheet Functions | |||
| NETWORKDAYS help with the formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
