Purpose
Return value
Syntax
=DAY(date)- date - A valid Excel date.
How to use
The DAY function returns the day component of a given date as a number between 1 to 31 from a given date. For example, with the date January 15, 2019 in cell A1:
=DAY(A1) // returns 15
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 extract and feed a day value into another function, like the DATE function. For example, to change the year of a date in cell A1 to 2020, but leave the month and day as-is, you can use a formula like this:
=DATE(2020,MONTH(A1),DAY(A1))
See below for more examples of formulas that use the DAY function.
Note: in Excel's date system, dates are serial numbers. January 1, 1900 is number 1 and later dates are larger numbers. To display date values in a human-readable date format, apply a number format of your choice.
Notes
- The date argument must be a valid Excel date.
- The DAY function returns #VALUE! if date is not valid.
DAY function examples
Add days to date
Get day from date
Semimonthly pay schedule
Add years to date
Sequence of years
Happy birthday message
Get nth day of week in month
Days in month
Get first day of month
DAY function videos
How to create date and time series with formulas
How to work with dates
Related functions
YEAR Function
The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula, like the DATE function.
MONTH Function
The Excel MONTH function extracts the month from a given date as number between 1 to 12. You can use the MONTH function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function.
DAY Function
The Excel DAY function returns the day of the month as a number between 1 to 31 from a given 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 extract and feed a day value into another function, like the...
DATE Function
The Excel DATE function creates a valid date from individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet.
