Dates - greater than or less than

[tinytutu]

I'm trying to find if C2, which contains a month (e.g., "September"), occurs after D1 (D1 is a full date, so I just extract the month; e.g., "June") AND before H1 (e.g., October). Here's my formula:

IF(AND(C2>TEXT(D1,"mmmm"),C2<TEXT(H1,"mmmm")),"Yes","No")

When I evaluate the formula, it says the first statement is true (September > June) but that the second statement is false (September < October). This makes no sense to me. Any help?

[humdingaling]

your converting dates to text then comparing text against text ?

[cbatrody]

If you are just trying to compare only the months, you can try the following formula:

D1: 25-Jun-14, H1: 25-Nov-14, C2: September

=IF(AND(MONTH(D1)<MONTH(DATEVALUE(C2&"-1")),MONTH(H1)>MONTH(DATEVALUE(C2&"-1"))),"YES","NO")

[tinytutu]

Thank you, cbatrody for the solution!!! And thanks to humdingaling for pointing out that I was comparing text to dates.

[cbatrody]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.

[tinytutu]

Done, thank you.