Formulas Based on Differences between months, as text?

[mnty89]

Hey so I cannot find the solution nor figure this out for some frustrating reason..

I have two columns that are Months. They have the month names spelled out fully. One is the original, the next is the adjusted. I want to say if the first month is later than the second, "Pulled In" if the first month is earlier than the second, "Pushed Out", if they are the same then blank "".

Examples of the data and intended outcomes below. It seems like it's reading these incorrectly since the months are coming out as texts of months..

Example Data

[TABLE="width: 281"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]MonthOLD[/TD]
[TD]MonthNEW[/TD]
[TD]Monthly_Shift[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD]August[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD]August[/TD]
[TD]Pulled_In[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD]September[/TD]
[TD]Pushed_Out[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD]August[/TD]
[TD]Pushed_Out[/TD]
[/TR]
</tbody>[/TABLE]

 

[mnty89]

If anyone ever needs this in the future I figured it out, basically need to convert the month text into a date value number to do a comparison with something like-

=IF(MONTH(DATEVALUE([MonthOLD]&" 1"))>MONTH(DATEVALUE([MonthNEW]&" 1")),"Pulled_In",IF(MONTH(DATEVALUE([MonthNEW]&" 1"))>MONTH(DATEVALUE([MonthOLD]&" 1")),"Pushed_Out",""))