Difference between revisions of "Manuals/calci/MONTH"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
==Description== | ==Description== | ||
*This function gives the month of a given date represented by a serial number. | *This function gives the month of a given date represented by a serial number. | ||
| − | *In <math>MONTH(sl.no), sl.no</math>, is the serial number of the month or we can give the date value in[[Manuals/calci/DATE | DATE ]]function format. | + | *In <math>MONTH(sl.no), sl.no</math>, is the serial number of the month or we can give the date value in[[Manuals/calci/DATE | DATE ]] function format. |
*MONTH("2/1/1997") for 2nd month. | *MONTH("2/1/1997") for 2nd month. | ||
*The result of the function is an integer 1 to 12(January to December) | *The result of the function is an integer 1 to 12(January to December) | ||
Revision as of 02:51, 1 January 2014
MONTH(sl.no)
- is the serial number of the month.
is the serial number of the month.Description
- This function gives the month of a given date represented by a serial number.
- In , 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)
, is the serial number of the month or we can give the date value in
Examples
- MONTH(32786)=10
- MONTH(74562)=2
- MONTH("9/1/1999")=9
- MONTH("20-may-2004")=5