Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(AND) with NETWORKDAYS
Hi,
Sure, =IF(AND(I6="",J6=""),"",IF(AND(I6="Half Day",J61),0.5,IF(AND(I6<1,J61),1,NETWORKDAYS(I6, J6,L1:L4)+1))) Here L1:L4 is a range containing any holidays. this function is part of the Analysis ToolPak so that needs to be attached for you or anyone you send this to. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "John" wrote: Hi Everyone I'm using this formula in a Vacation Planner, its working fine but I would like to know if I can incorporate "NETWORKDAYS" in the same formula. =IF(AND(I6="",J6=""),"",IF(AND(I6="Half Day",J61),0.5,IF(AND(I6<1,J61),1,J6-I6+1))) Thanking you in advance John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(AND) with NETWORKDAYS
Hi Shane
Thank you very much, its working perfectly. Regards John "ShaneDevenshire" wrote in message ... Hi, Sure, =IF(AND(I6="",J6=""),"",IF(AND(I6="Half Day",J61),0.5,IF(AND(I6<1,J61),1,NETWORKDAYS(I6, J6,L1:L4)+1))) Here L1:L4 is a range containing any holidays. this function is part of the Analysis ToolPak so that needs to be attached for you or anyone you send this to. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "John" wrote: Hi Everyone I'm using this formula in a Vacation Planner, its working fine but I would like to know if I can incorporate "NETWORKDAYS" in the same formula. =IF(AND(I6="",J6=""),"",IF(AND(I6="Half Day",J61),0.5,IF(AND(I6<1,J61),1,J6-I6+1))) Thanking you in advance John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS | Excel Discussion (Misc queries) | |||
NETWORKDAYS = 0 | Excel Discussion (Misc queries) | |||
Help on Networkdays | Excel Worksheet Functions | |||
NETWORKDAYS Help | Excel Worksheet Functions | |||
Networkdays? | Excel Discussion (Misc queries) |