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
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
=NETWORKDAYS('Recap Report'!$A$7,INDIRECT("'Recap Report'!A"&$K$3))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"parteegolfer" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
Thanks Bob!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks