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 here:
http://www.cpearson.com/excel/DateTimeWS.htm#Quarter

--
Andy.


"rita" <[email protected]> wrote in message
news:[email protected]...
>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?
>