View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anna Wood Anna Wood is offline
external usenet poster
 
Posts: 12
Default Lumping dates into quarters by year

I have a list of dates extending out for the next 8 years and I need to put
them in the quarter/year category - i.e., 3Q09 for a date that is 10/12/09.

Is there a formula to convert dates to this type of format?