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

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