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

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

In Cell A3 Sheet2 enter

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




"Tim Russell" <[email protected]> wrote in message
news:[email protected]...
> 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 ***

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