View Single Post
  #1   Report Post  
rita
 
Posts: n/a
Default 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?