You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dilip" wrote in message
...
Hi Ashish,

Thanks a lot! now the formula working fine.

Regards

"Ashish Mathur" wrote:

Hi,

Try this.

=IF(AND(A4<"",(NETWORKDAYS(B4,C4,indirect(D4)))2 ),NETWORKDAYS(B4,C4,indirect(D4)))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dilip" wrote in message
...
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