Month

Description of formula:
Returns the month of a date. The month is an integer ranging from 1 to 12.
Syntax:
MONTH(date|datetime|utc)
Parameters:
date(type:date)
The date of the month you are trying to find.
datetime(type: datetime)
The date with time of the month you are trying to find.
utc(type:UTC)
The date with time in a UTC format of the month you are trying to find.
Returned type:
Number
examples:
=month(date(2016,1,1))
=month (A1)
=month (datetime(2018,2,3,12,30))
=month (UTC(D2))
 
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk