Excel has built in formulas to get year and month values They are YEAR and MONTH respectively They return the values as their name refer To increase month by 1, we add 1 to return the value of the MONTH function Because the day of month is not a concern for this type of list, the first day of a month, 1 becomes a proper day value =DATE Microsoft Excel has several functions that allows manipulation of date and time, and one of them is MONTH(), which returns the month of a date in number ranging from 1 (for January) to 12 (December) Some Microsoft Office Excel users may prefer the month to be shown or displayed as month name in text instead of number, in the form of January, February, March Where serial_number is any valid date of the month you are trying to find For the correct work of Excel MONTH formulas, a date should be entered by using the DATE(year, month, day) function For example, the formula =MONTH(DATE(15,3,1)) returns 3 since DATE represents the 1st day of March, 15 Formulas like =MONTH("1Mar15") also work fine,
How To Convert Date To Month And Year In Google Sheets
