Date functions-enter a formulae that will calculate the current month

Hello please can anyone help with this:

I would like to enter a formulae that will calculate the current month i.e. December 08 and then also Calculate the previous month and year and enter the results in the same cell in a format such as this:

December 08 v December 07

can anyone suggest any ideas pls.
Michelle

I couldnt find anything that would segregate just the monthly text from a date....so here is my solution.

I have the twelve months listed and numbered. You can use the

Please Login or Register  to view this content.

command to identify the current months number...and use that in a vlookup against the twelve month listed database so you get the desired text. Tweak it a bit to get the formula I have in cell A1

Try:

=TEXT(TODAY(),"mmmm yy") & " v " & TEXT(DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()),"mmmm yy")

HTH

Jason

and i went for
=TEXT(TODAY(),"mmmm yyyy") &" v "&CHOOSE(MONTH(EDATE(NOW(),-1)),"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec")&" "&YEAR(EDATE(NOW(),-1))

Originally Posted by martindwilson

and i went for
=TEXT(TODAY(),"mmmm yyyy") &" v "&CHOOSE(MONTH(EDATE(NOW(),-1)),"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec")&" "&YEAR(EDATE(NOW(),-1))

Just an FYI on the EDATE formula....(Per the Excel Help)

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
If necessary, follow the instructions in the setup program.