Excel 2007 : Formula To Output What Range A Date Is In

Hi,

I'm looking to create a formula that looks at a date and then outputs what range that date is in.

For example:

The monthly period for the transactions i'm creating a report for runs from the 16th - 15th of the following month. So if a transaction occurred on 7th Jan I would like the formula to output 'Dec - Jan' so I know that that transaction is shown on the 'Dec - Jan' statement.

I hope this makes sense, any queries give me a shout.

Thanks in advance,

Snook

Here, try this:

=TEXT(G2-15,"mmm")&" - "&TEXT(G2,"mmm")