The DAY function is used to extract the day value from a date in Excel. It returns the day of the month (a number from 1 to 31) corresponding to a specific date.



date The date from which to extract the day.

About DAY

When you need to isolate the day component from a date in Excel, the DAY function comes to the rescue. It simplifies the process of retrieving the day value for a given date, offering convenience in various spreadsheet applications. This function is particularly handy when dealing with datasets that involve date-related calculations and analyses. By utilizing the DAY function, you can efficiently dissect dates into their individual day components, facilitating a deeper dive into temporal information embedded in your data.


Suppose cell A1 contains the date 03/15/2022. To extract the day value (15) from this date, you can use the DAY function as follows: =DAY(A1)

If you have a dataset with a column of dates and you want to create a new column displaying only the day values for each date, you can apply the DAY function to extract the day components efficiently.


What is the range of values returned by the DAY function?

The DAY function returns a numerical value representing the day of the month, ranging from 1 to 31, corresponding to the specified date.

Can the DAY function be used with dates in different date formats?

Yes, the DAY function can be used with dates in various date formats as long as Excel recognizes the input as a valid date value. Excel is flexible in interpreting date formats, allowing you to extract day values from dates formatted differently.

Is the DAY function sensitive to time components in the provided date?

No, the DAY function solely focuses on extracting the day component from a date and disregards any time information associated with the date value. It operates strictly on the day of the month within the date provided.

Related functions