Hi Paul,

I removed the quotes but i get #REF error.

"Paul" wrote:

Try removing the " from around DA2

=NETWORKDAYS($CK3,$CK3+14,INDIRECT(DA2))


--
If the post is helpful, please consider donating something to an animal
charity on my behalf.


"LABKHAND" wrote:

Hi All,

I have the following formula in cell A1 :
=NETWORKDAYS($CK3,$CK3+14,FY09_Holidays) which works fine. But I am trying
to change this formula so that I use a target cell's value (DA2) to replace
the "FY09_Holidays" string in the above formula. So if DA2 has the value of
FY09_Holidays, then I tried using the INDIRECT function in cell A1 this way:

=NETWORKDAYS($CK3,$CK3+14,INDIRECT("DA2")).

This gives me a value error! Some sort of wrong data type error!

If this function works, my code will be very flexible for the following
years since I can just change the value of DA2 cell to FY10_Holidays without
a need to change the cell formulas using the networkdays function all over my
workbook.

BTW, when I insert the function =INDIRECT("DA2") in another cell, I do get
the "FY09_Holidays" value returned. so I am not sure what is going on when it
is part of the above networkdays function!

Can you please help?