| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)???
I have a list of dates, and I need to find out which season each one
falls in. From all of the date researching that I have done, I cannot seem to get my answer. Here is the issue. I have a list of dates: 1/24/02 5/14/03 7/11/02 8/3/05 etc Then I have 4 seasons, which are the same every year, so year is not included. They are as follows: A = 10/25 - 4/30 B = 5/01 - 7/24 C = 7/25 - 9/05 D = 9/06 - 10/24 So for each date, I need to see if it equals A, B, C or D.... Any thoughts? I have tried this a number of ways, including trying to split them up, and using Month() and Day() functions, but everything comes back invalid. I hope some can see what I am not seeing! Thank you, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I plot "Month, Year" on the x-axis for prior to 1900? | Charts and Charting in Excel | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| Working out age from "Day" "Month" "Year" | Excel Worksheet Functions | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
Threaded Mode
