Return the number corresponding to a given month


 A
1=TODAY() = 19/05/2024
2=NOW() = 5/19/2024 13:52
3January
4November
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 - 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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top