DAY

Get the day as a number (1-31) from a date

Example

Sponsored Link

DAY

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.

Sponsored Link

0 votes. 0 / 5