This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.
Excel function · Dates
DAY
Returns the day of the month of a date, from 1 to 31.
What it does
DAY returns the day of the month as a number. It doesn't tell you the day of the week; that is WEEKDAY.
Syntax
=DAY(serial_number)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- serial_number
- The date to read, usually a cell.
Example
Which day of the month is the date in A2?
| A | B | |
|---|---|---|
| 1 | Date | Day |
| 2 | 2026-02-28 | 28 |
The formula in B2:
=DAY(A2)Result: 28
2026-02-28 is the 28th day of February, so the result is 28.
Common mistakes
- Confusing it with the day of the week. Monday or Sunday comes from
WEEKDAY. - Using it to count days between dates. Subtract the dates, or use
DAYS.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | DAY | , |
| Deutsch | TAG | ; |
| Français | JOUR | ; |
| Español (España) | DIA | ; |
| Español (México) | DIA | , |
| 日本語 | DAY | , |
| 한국어 | DAY | , |
| 繁體中文 | DAY | , |
| ไทย | DAY | , |
| ខ្មែរ | DAY | , |
| Tiếng Việt | DAY | ; |