Quarters

P

PAL

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.
 
J

Jacob Skaria

Suppose A1 = Date. Use the below formula

="Q" & ROUNDUP(MONTH(A1)/3,0) & ", '" & RIGHT(YEAR(A1),2)

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top