DAY
Date & Time
Extracts the day of the month from a date as a number from 1 to 31.
Translations
EnglishDAY
FrenchJOUR
SpanishDIA
GermanTAG
ItalianGIORNO
PortugueseDIA
DutchDAG
PolishDZIEŃ
RussianДЕНЬ
TurkishGÜN
CzechDEN
HungarianNAP
SwedishDAG
DanishDAG
FinnishPÄIVÄ
Syntax
DAY(serial_number)Arguments
serial_numberThe date to extract the day from
Examples
=DAY(TODAY())1-31
Returns today's day of month
=DAY("15/06/2024")15
Returns 15 from the date
=DAY(EOMONTH(A1,0))Last day
Gets the last day of the month
Tips & Best Practices
- •Returns a number from 1 to 31
- •Use EOMONTH to find the last day of a month
- •Combine with DATE to manipulate dates
Common Mistakes
- •Using DAY on a text string that looks like a date, which returns a #VALUE! error instead of the day number
- •Confusing DAY (extracts the day-of-month number) with WEEKDAY (returns the day of the week) - they answer completely different questions
- •Expecting DAY to return a day name like "Monday" - it only returns a number from 1 to 31
Related Functions
Frequently Asked Questions
What's the difference between DAY and WEEKDAY?
DAY returns the day-of-month number, like 15 for the 15th. WEEKDAY returns which day of the week it falls on, like 1 for Sunday.
Why does DAY return a #VALUE! error?
The cell is probably storing the date as text rather than an actual date - try DATEVALUE to convert it first.
Can DAY tell me the number of days in a month?
Not directly, but a common trick is DAY(EOMONTH(A1,0)), which returns the last day-of-month number for the month containing the date in A1.
Need to translate a formula using DAY?
Use our translator to convert your complete formula