Return the number corresponding to a given month


 A
1=TODAY() = 02/12/2019
2=NOW() = 12/2/2019 7:03
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 serial number of the current system date and time.
TODAY - The 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


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