I have a date in cell G7 (say 21 Jun 2005), in a seperate text note I
want to say " as at the end of May 2005".

Where the date in G7 varies and the date in the text is always the
previous month.

Can any one assist please.

Try:

="as at the end of "&TEXT(DATE(YEAR(G7),MONTH(G7)-1,1),"mmm yyyy")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Box666" wrote in message
oups.com...
I have a date in cell G7 (say 21 Jun 2005), in a seperate text note I
want to say " as at the end of May 2005".

Where the date in G7 varies and the date in the text is always the
previous month.

Can any one assist please.

Try...

=" as at the end of "&TEXT(DATE(YEAR(G7),MONTH(G7)-1,1),"mmm yyyy")

If you want the month displayed in full, change...

"mmm yyyy"

to

"mmmm yyyy"

Hope this helps!

In article .com,
"Box666" wrote:

I have a date in cell G7 (say 21 Jun 2005), in a seperate text note I
want to say " as at the end of May 2005".

Where the date in G7 varies and the date in the text is always the
previous month.

Can any one assist please.

One way assuming the value in G7 is a numeric date and not text

="as at the end of "&TEXT(DATE(YEAR(G7),MONTH(G7)-1,DAY(G7)),"mmm yyyy")



--

Regards,

Peo Sjoblom

"Box666" wrote in message
oups.com...
I have a date in cell G7 (say 21 Jun 2005), in a seperate text note I
want to say " as at the end of May 2005".

Where the date in G7 varies and the date in the text is always the
previous month.

Can any one assist please.