Difference between revisions of "Manuals/calci/MONTH"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
==Examples== | ==Examples== | ||
| − | #MONTH(32786)=10 | + | #=MONTH(32786) = 10 |
| − | #MONTH(74562)=2 | + | #=MONTH(74562) = 2 |
| − | #MONTH("9/1/1999")=9 | + | #=MONTH("9/1/1999") = 9 |
| − | #MONTH("20-may-2004")=5 | + | #=MONTH("20-may-2004") = 5 |
==See Also== | ==See Also== | ||
Revision as of 03:04, 3 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)
, Examples
- =MONTH(32786) = 10
- =MONTH(74562) = 2
- =MONTH("9/1/1999") = 9
- =MONTH("20-may-2004") = 5