Create an empty google spreadsheets. Enter following
=ROW() =MONTH(A1)
=ROW() =MONTH(A2)
=ROW() =MONTH(A3)
=ROW() =MONTH(A5)
output:
1 -January-
2 -December-
3 -December-
4 -December-
5 -December-
6 -December-
7 -December-
8 -December-
9 -December-
10 -December-
11 -December-
12 -December-
Is there a workaround?
Seems like a ridicolous bug/intentional bad design choice in Google Spreadsheets
Naturally, =MONTH(=ROW())
does not work correctly either
solution is formatting. first, format first row and put validation as a date. then, format second row as a date (month only, verbal). then enter first two dates. then autofill the rest of date by selecting first two and grabbing the corner of the selection (autofill
A
column)then enter
=A1
toB1
, and autofillB
column too