I’m trying to return a month from a date in Google sheets, but I’m not sure what’s happening.
Cell A2 is populated with a date of 12/30/2022. If I select that cell, go to Format > Number, the checked item in the list confirms it’s indeed a date formatted as m/dd/yyyy.
Cell B2 has the formula =month(A2), but returns Jan as the month.
What gives?
I’ve also tried copying A2 into a separate column, converting that into a number (44,925). I’ve also tried to run the month formula on that, and it also returns the same incorrect month as above.
user1313927 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.