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.