If Date is on or after Oct 1, but before Jan 1

jomili

New Member
Joined
Dec 15, 2009
Messages
33
Not sure how to construct a formula to check for between date ranges for any year, not just this year. I need to return a specific value if today's date is on or after Oct 1, but before Jan 1, and a separate value if not. Any help is appreciated.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,799
Office Version
365
Platform
Windows
If your date field is a valid date field (and let's say it is in cell A1), just check the month number, i.e.
Code:
=IF(MONTH(A1)>=10,"value to return","")
 

jomili

New Member
Joined
Dec 15, 2009
Messages
33
I hate it when I overly complicate things. I was getting all wrapped up in how to differentiate with the year changes, and completely forgot that the months have unique numbers. Thanks so much for pointing me in the right direction!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,799
Office Version
365
Platform
Windows
You are welcome!

I hate it when I overly complicate things.
No worries! It happens to all of us sometimes!
 

Forum statistics

Threads
1,085,840
Messages
5,386,270
Members
401,990
Latest member
Lochlan 1997

Some videos you may like

This Week's Hot Topics

Top