Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-288
4200A-901-01 Rev. C / February 2017
MONTH Calc worksheet function
This command returns the month component of the supplied date and time serial number or text-formatted date.
Usage
MONTH(
Serial_number
)
Serial_number
The date as a serial number or as text (for example,
06-21-15
or
21-Jun-15
)
Details
MONTH
returns a number ranging from 1 (January) to 12 (December).
You need to extract the month from the serial number created by the
NOW
function.
Example
=MONTH("07-21-16")
=MONTH(34626)
=MONTH(NOW())
Returns
7.0000E+0
.
Returns
10.0000E+0
.
Returns the present month of the present year.
Also see
(on page 6-278)
(on page 6-280)
(on page 6-287)
(on page 6-289)
(on page 6-291)
(on page 6-296)