Using Date Ranges

T

tchillie

I have a table of information in Excel. One of the columns is a date.
I would like to automatcally return a value if the date falls within
certain ranges. For example, if the date is between 1/1/01 and
5/31/01 then return "A." But if the date is between 6/1/01 and
5/31/02 then return "B." The problem I have is that the date ranges
cross years and are not always 365 days. I have done this using
formulas, but with 8 ranges, I have a nested IF statement with 7 If's.
Any suggestions using VBA?

If anyone wants more info, just let me know.
 
A

Arvi Laanemets

Hi

Something like
=CHOOSE(MATCH(A1,{38352,38168,37986,37802,37621,37437,37256,37072,36891},-1)
,"A","B","C","D","E","F","G","H")

where A1 contains date, and 5-digit numbers in MATCH array represent dates
in descending order (in my example they are 31.12.2004, 30.06.2004,
31.12.2003, ..., 31.12.2000). Of course the number of matches isn't
infinite, but 29 is considerable better as 7.
 
Top