Hi,,

I'm not sure if this request should be here under the VB forum,,I'm not even sure if its possible to do,,

What I want to be able to do is,,press the Q key and either Q1, Q2, Q3 or Q4 based on certain parameters appear in that cell,,

Hopefully I can explain this clearer,,

In column A of my spreadsheet heading 'Quarter', I want to be able to specify which quarter of the year a request was made,,so when I press Q

> if the date is within 01/01/14 and 31/01/14 'Q1' will appear

> if the date is within 01/04/14 and 30/06/14 'Q2' will appear etc,,I'm sure you can workout Q3 and Q4,,

Ive named a cell A1 'TODAY' for reference it has the formula =TODAY() in it and shows whatever the date,,

I have looked at the DATE commands available but I don't think any could do what I need, that's why I was thinking I needed a piece of VB code,,

Any help would be much appreciated,,

Regards,
KJMOSP