Question : google sheets convert abbreviation of month to number
Answered by : charlesalexandre-roy
# Basic syntax:
=MONTH("Apr"&1) # returns 4
# Where:
# - &1 concatenates 1 to the month string allowing it to be recognized
# as a date by the MONTH function
Source : https://www.statology.org/convert-month-name-number-in-google-sheets/ | Last Update : Sun, 17 Jul 22