IF(AND) with NETWORKDAYS

[John]

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",J6>1),0.5,IF(AND(I6<1,J6>1),1,J6-I6+1)))
Thanking you in advance
John

 

[ShaneDevenshire]

Hi,

Sure,

=IF(AND(I6="",J6=""),"",IF(AND(I6="Half
Day",J6>1),0.5,IF(AND(I6<1,J6>1),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.

 

[John]

Hi Shane
Thank you very much, its working perfectly.
Regards
John