Formula to convert date to month / year question

[bravura]

I used to be able to convert a date to month or year using formula like =Text(A2, "MMMM"), but suddenly i have to change the formula to =Text(A2*29, "MMMM"), otherwise regardless of the date, it will only display January. And i don't yet know how to do the year. Anyone know why this suddenly changed for me and how do I go back to old formula? This began recently as well as i have to keep going back to settings to reset to Automatic calculations.

 

[Joe4]

What exactly is in cell A2?
Can you post some examples?

And tell us what this formula returns:

=ISNUMBER(A2)

 

[bravura]

i feel like i'm taking crazy pills. i went back and opened the same doc and tried to replicate, but it's working fine now. IDK WTH happened. thanks for your look.

 

[Joe4]

You are welcome. Glad you got it sorted.

You mentioned about messing with the Calculation mode. Maybe it was set to Manual or something.