Manuals/calci/MONTH

MONTH(sl.no)

• $sl.no$ is the serial number of the month.

Description

• This function gives the month of a given date represented by a serial number.
• In $MONTH(sl.no)$, $sl.no$ is the serial number of the month or we can give the date value in DATE function format.
• MONTH("2/1/1997") for 2nd month.
• The result of the function is an integer 1 to 12(January to December)

Examples

1. MONTH(32786)=10
2. MONTH(74562)=2
3. MONTH("9/1/1999")=9
4. MONTH("20-may-2004")=5

See Also

• DAY
• DATE
• YEAR