MONTH

[689touch]

Good afternoon,

I am working on a spreadsheet someone else has designed and seen the following as part of a formula:

IF(MONTH(F$48 & 1) >= $C283

Where F48 contains the word January

And C283 contains the number 1

Could someone please explain this. THANK YOU!

 

[AlphaFrog]

The quick answer is the formula is testing if the Month text in F48 is >= to the numeric month in C283. It converts the January text into a month-number to compare it to the C283 number.

F$48 & 1 converts the January text into a Date (the 1st of the month) that Excel can recognize as a date and not just text. The MONTH function then converts that Date into a month number (1 to 12) to then compare to the number in C283.

 

[689touch]

Thank you so much for the solution and for explaining it so well. THANK YOU!!