MONTH

MONTH(date)

Returns the month from a given date (Integer).

date

The date you want the month of (Variant).

REMARKS

* The value returned is between 1 and 12.
* The "date" can be any date, numeric or string expression.
* If "date" is Null, then Null is returned.
* You can use the DATE function to return the current system date.
* You can use the DAY function to return the day from a given date.
* You can use the MONTHNAME function to return the month as a string.
* You can use the NOW to return the current system date and time.
* You can use the YEAR function to return the year from a given date.
* The equivalent .NET function is [[Microsoft.VisualBasic.DateAndTime.Month]]
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print Now()                      '= 01/09/2024 23:56:17  
Debug.Print Month(Now())               '= 9  
Debug.Print Month(#12/6/2024#)         '= 12  
Debug.Print Month("1 January 2024")    '= 1  
Debug.Print Month("February 12, 2020") '= 2  
Debug.Print Month("01/02/2024")        '= 2  
Debug.Print Month("1 Feb 2024")        '= 2  
Debug.Print Month(1)                   '= 12  
Debug.Print Month(32)                  '= 1  
Debug.Print Month(33)                  '= 2  
Debug.Print Month(256)                 '= 9  
Debug.Print Month(365)                 '= 12  
Debug.Print Month(2000)                '= 6  

Dim lDate As Date 
lDate = 32616 
Debug.Print Month(lDate)               '= 4