Return the number corresponding to a given month

1=TODAY() = 09/07/2020
2=NOW() = 7/9/2020 12:28
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

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