Date ranges

[62deadfly]

I have a list of dates, and wish to be able to group them into set date periods.

For instance in cells C4:C15, there are the list of dates ranging from Jan 3rd 2010 to November 29th 2010. I want to have the adjacent cell in Column D to display what Quarter these dates are in (1, 2, 3 or 4). I can do this easily for just one end-date, but when 4 date ranges (Jan 1-Mar 31, Apr 1-Jun 30 etc) are involved I can’t seem to find a way through.

Cheers,

[Paul]

Try the following in D4 and filled down to D15:

=LOOKUP(MONTH(C4),{1,4,7,10},{"Q1","Q2","Q3","Q4"})

Hope that helps!

[sigfreid]

Not 100% sure I know what you need but would

if(C3 +1 > Q1 start DDMM < Q2 start DDMM, 1, if (C3 +1 > Q2 start DDMM < Q3 start DDMM, 2, if (C3 +1 > Q3 start DDMM < Q4 start DDMM, 3, (if C3 +1 > Q4 start DDMM < Q1 start DDMM, 4 , ""))))

in D3 work?

[62deadfly]

Sorted, thanks guys.