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.