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)
Argument |
Description |
Permitted values |
|---|---|---|
date |
Date from which you need to obtain the day |
Reference 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.