Use a sheet name in a formula?

L

Lee

Depending on the result of a test - =IF(APR!H52>0,... 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
 
B

Bob Phillips

B10:=IF(APR!H52>0,"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)
 
Top