Property way to calculate months using a date

[mcmuney]

Hi, I'm running into an issue when using the following calculation:

I have 2 dates:

A1 4/30/2018
B1 10/31/2018

I'm using this calculation, IF(text(B1,"M")<text(A1,"M"),"yes","no")

Result is showing "yes" (10<4=True)

Math works for Jan-Sep, but stops when the month is double digits. Is there a fix for this?

Thanks in advance.

 

[MARK858]

If your regional date format is mm/dd/yyyy why not just use

IF(MONTHt(B1)<MONTH(A1),"yes","no")

 

[mcmuney]

Wow! Just had a duh moment. Thanks.