Correct Format for formula
 

How would I use a value from another cell as part of a variable in this
example?

=NETWORKDAYS('Recap Report'!$A$7,'Recap Report'!A&(VALUE($K$3)))

Regards
ParTeeGolfer


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=535661

Correct Format for formula
 

=NETWORKDAYS('Recap Report'!$A$7,INDIRECT("'Recap Report'!A"&$K$3))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"parteegolfer"
wrote in message
...

How would I use a value from another cell as part of a variable in this
example?

=NETWORKDAYS('Recap Report'!$A$7,'Recap Report'!A&(VALUE($K$3)))

Regards
ParTeeGolfer


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile:
http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=535661

Correct Format for formula
 

Thanks Bob!


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=535661