Excel DAY Function

Excel DAY Function

Summary

The Excel DAY function returns the day of the month as a number between 1 to 31 when given a date. You can use the DAY function to extract a day number from a date into a cell. You can also use the DAY function to feed a day value into another formula, like the DATE function.

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

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.

Excel DAY Function

Summary

The Excel DAY function returns the day of the month as a number between 1 to 31 when given a date. You can use the DAY function to extract a day number from a date into a cell. You can also use the DAY function to feed a day value into another formula, like the DATE function.

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

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.