- I have a column of dates and want to extract the month for sorting grouping purposes.
So in A2 I have 2018-01-01 formatted as NN, MMM DD YYYY I get Mon, Jan 01 2018
in B2 fI have =weekday(a2) and get Monday
in C3 I have = month(a2) and get December
when the month changes to February, I get month() = January
For expediency I have changed the formula in C2 to be =month(A2)+1 and get the right month.
My question is, what am I doing wrong in this case. It’s always worked before.
Any hints would be appreciated.