Purpose
Get the day as a number (1-31) from a date
Return value
A number (1-31) representing the day component in a date.
Syntax
=DAY (date)
Arguments
- date - A valid Excel date in serial number format.
Usage notes
Date must be a valid Excel date in serial number format. For example, the date Jan 1, 2000 is equal to the serial number 32526 in Excel on Windows.
Excel only handles dates after 1/1/1900.