Use a sheet name in a formula?
 

Depending on the result of a test - =IF(APR!H520,... I want to insert the
name of the sheet into a cell on another sheet and use it to automatically
insert the last day of the month in a cell.

E.g. on sheet APR, if H52 is greater than 0, the sheet CLAIM B10=APR.
Then if B10 =APR then B11 contains 30 April 06

Can this be done and if so can someone point me in the right direction please?

Cheers,
Lee

Use a sheet name in a formula?
 

http://www.cpearson.com/excel/excelF.htm#SheetName
--
Brevity is the soul of wit.


"Lee" wrote:

Depending on the result of a test - =IF(APR!H520,... I want to insert the
name of the sheet into a cell on another sheet and use it to automatically
insert the last day of the month in a cell.

E.g. on sheet APR, if H52 is greater than 0, the sheet CLAIM B10=APR.
Then if B10 =APR then B11 contains 30 April 06

Can this be done and if so can someone point me in the right direction please?

Cheers,
Lee

Use a sheet name in a formula?
 

B10:=IF(APR!H520,"APR","")
B11:
=IF(B10<"",DATE(YEAR(TODAY()),MONTH(DATEVALUE("1-"&B10&"-"&YEAR(TODAY())))+
1,0),"")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Lee" wrote in message
...
Depending on the result of a test - =IF(APR!H520,... I want to insert the
name of the sheet into a cell on another sheet and use it to automatically
insert the last day of the month in a cell.

E.g. on sheet APR, if H52 is greater than 0, the sheet CLAIM B10=APR.
Then if B10 =APR then B11 contains 30 April 06

Can this be done and if so can someone point me in the right direction
please?

Cheers,
Lee