IF(AND) with NETWORKDAYS

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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.
 
Back
Top