View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sumitk
 
Posts: n/a
Default Bucketing data based on DATE Range criteria

Hi all. Here's the situation... I have a list of numbers that I need to place
in one of four columns based on on the expiration date of the numbers. The
date ranges a

I. WIthin 1 Year
II. 1 to 3 years
III. 3 - 5 Years
IV. Over 5 Years

So basically if the exp. date for the number is within 1 year, it should be
in Category A, if its between 1-3 years then category B and so on..

The numbers are in col. A and exp. dates are in col. B. The buckets
(I,II,III,IV) are in col. C thru E.

I have already calculated what the actual dates should be for buckets I -
IV. I had to make that the formula since the date ranges are calculated based
on the current day (as of when the analysis is done).

Would appreciate any suggestions.

Thanks in advance.

sk