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.