Thread: Quarters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default Quarters

I have a few hundred rows, one of the columns has a date, the other column a
number value. I want to group the dates by quarters (the range is 3 years
back to 07, but will grow over time). Is there a way to look at the date and
assign it a quarter year (Q1, '07). I will make the assigment in another
column. I assume I can get the averages for a given quarter via an array.

Thanks.