"As of" & "July 31, 2005"
 

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 ***

"As of" & "July 31, 2005"
 

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 ***

"As of" & "July 31, 2005"
 

In Cell A3 Sheet2 enter

="As of " & TEXT(Sheet1!A1,"mmmm dd, yyyy")




"Tim Russell" wrote in message
...
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 ***

"As of" & "July 31, 2005"
 

sorry.. another way is to custom format the cell. you could do "As of "mmmm
d, yyyy

"Kasey Kern" wrote:

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 ***