'to return the address of A1
=Cell("address",A1) - returns $A$1

Create a sheet named 11112009 and try
=Cell("address", INDIRECT(TEXT(TODAY(),"mmddyyyy") & "!A1")))
- returns '[Book3]11112009'!$A$1

The last formula creates a link that sends med to sheet 11112009
Jacob Skaria skrev: