Return the number corresponding to a given month

	A
1	=TODAY() = 13/11/2024
2	=NOW() = 11/13/2024 19:58
3	January
4	November
5	=MONTH("1/"&A3) = 1
6	=MONTH("1/"&A4) = 11
7	=CHOOSE(MATCH(LEFT(A3, 3), {"Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"Aug";"Sep";"Oct";"Nov";"Dec"}, 0), 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) = 1
8	=CHOOSE(MATCH(LEFT(A4, 3), {"Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"Aug";"Sep";"Oct";"Nov";"Dec"}, 0), 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) = 11

Built-in Functions

NOW - The date serial number of the current system date and time.
TODAY - The date serial number representing today's date.
MONTH - The month as an integer given a date serial number.
CHOOSE - The value in a row (or column) based on an index number.
LEFT - The first or left most characters in a text string.
MATCH - (XMATCH) The position of a value in a list, table or cell range.

Related Formulas

Return the current month
Return a date in a particular format