Date formula with text in same cell but using previous month not current month

Hi

I have put the following forumla in to my spreadsheet

="Scores"&" "&TEXT(TODAY(),"mmmm yyyy")

Which currently gives me Scores October 2012 but I need it to show the previous month not the current month.

So Scores September 2012

I have tried putting in a -1 in various places but cant seem to get it to work.

Is there a better formual to use with the text

Thanks

Try this

="Scores "&TEXT(TODAY()-DAY(TODAY()),"mmmm yyyy")

You can even use

=TEXT(TODAY()-DAY(TODAY()),"""Scores ""mmmm yyyy")

You could do this:

="Scores "&TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,1),"mmmm yyyy")

Hope this helps.

Pete

Thanks guys much appreciated.

Such a simple change to the forumla (I could kick myself for not seeing what I needed to do)

Thanks again
Tracy