Oops I totally misunderstood your question..
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Dilip

Suppose you have the list of holidays in G1:G10 refer the range in formul as
below

=IF(AND(A4<"",(NETWORKDAYS(B4,C4,G1:G10))2),NETW ORKDAYS(B4,C4,G1:G10))

If you have named the range G1:G10 as holiday1 refer that as below

=IF(AND(A4<"",(NETWORKDAYS(B4,C4,holiday1))2),NE TWORKDAYS(B4,C4,holiday1))

If this post helps click Yes
---------------
Jacob Skaria


"Dilip" wrote:

I have created an excel formula with names in it.
I have created a set of names and I want to call the names given in the row
through formula.
3 A B C D
4 123 4/12/09 4/16/09 HOLDAY1
=IF(AND(A4<"",(NETWORKDAYS(B4,C4,D4))2),NETWORKD AYS(B4,C4,D4))
here HOLIDAY1 is one among the list of holdays listed in a separate column.
When I use the row number in the formula, it is not considering my name value.

Is there way to include or call name through formula