The MONTH
function returns the month of the year
when given a date value.
- The syntax
for the function is MONTH (date)
. The "date"
must be a date value or a recognizable
date format in Excel.
Excel recognizes
other date formats and automatically
converts them into date values then
the month is extracted from
the date value and a number is given
between 0 and 12.
For example: MONTH
(14-May-2003) = 5 and MONTH (12/31/2003)
= 12.
In addition the
MONTH function can extract the month
of the year directly from the date
value MONTH(39099)
=1
|
