Skip to main content

DAY

The DAY function returns the day of the specified date.

This function can be useful when you need to retrieve the day from a date for analysis, grouping, or calculations.

Syntax​

DAY(date)

ArgumentDescriptionPermitted values
dateDate from which you need to obtain the dayReference to a cell containing a date, a function that returns a date value, a row containing a date in a valid format

Examples of use​

Direct indication of the date in the formula

=DAY("01/01/2025")

Result: 1.

Use with reference to cell

=DAY(A1)

If the cell contains a valid date, the formula will return the day from that date.

Notes​

  • The function returns an integer between 1 and 31, depending on the date.
  • If the argument is not a valid date, the function will return the #VALUE! error.