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.