Change date to quarter of a year
 

I have dates in one column and I would like to put in the next column the
quarter of the year. Example if in cell "A1" I enter date "30 Jan 2005", I
would like to show "1Q2005" or similarin Cell "B1".
Can you help?

Hi
Have a look he
http://www.cpearson.com/excel/DateTimeWS.htm#Quarter

--
Andy.


"rita" wrote in message
...
I have dates in one column and I would like to put in the next column the
quarter of the year. Example if in cell "A1" I enter date "30 Jan 2005", I
would like to show "1Q2005" or similarin Cell "B1".
Can you help?