Within 6 months, Within 1 year and so on...

[Guest]

I am trying to take a column of data and 'bucket' it.

For example if the # of days is 124, I would like to display within 6
months. I will need to go up to 4 years in 6 month intervals with the data
point falling into only one bucket.

 

[Guest]

With the number of days in A1.........

=LOOKUP(A1,{0,183,366,549,732,915,1098,1281},{1,2,3,4,5,6,7,8})

hth
Vaya con Dios,
Chuck, CABGx3