Try this formula in A3:
="As of "&A1


"Tim Russell" wrote:

Sheet 1
A1 = 7/31/05 (formated as date) = July 31, 2005


Sheet 2
I want A3 to read "As of July 31, 2005". But I want the date to be
pulled from sheet 1, cell A1.

So if I change sheet 1, A1 to August 31, 2005, then Sheet 2, A3 changes
to read "As of August 31, 2005".



How is this done?

Thanks.


*** Sent via Developersdex http://www.developersdex.com ***