Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Date Ranges
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM and IF using two date ranges | Excel Discussion (Misc queries) | |||
How do I get a new calculated date from different date ranges? | Excel Worksheet Functions | |||
Date Ranges | Excel Discussion (Misc queries) | |||
compare date to various date ranges and sum value | Excel Worksheet Functions | |||
sum of date ranges | Excel Worksheet Functions |