Exceljet

Quick, clean, and to the point

Get day from date

Excel formula: Get day from date
Generic formula 
=DAY(date)
Summary 

If you need to extract the day from a date, you can use the DAY function. The date must be in a form that Excel recognizes as a valid date. In the example shown, the formula in cell B5 is:

=DAY(B5)
Explanation 

The DAY function takes just one argument, the date from which you want to extract the day. In the example, the formula is:

=DAY(B5)

B5 contains a date value for January 5, 2016. The DAY function returns the number 5 representing the day component of the date.

Note that you can use DAY to extract the day from a day entered as text:

=DAY("1/5/2016")

But this can produce unpredictable results on computers using different regional date settings. In general it's better (and more flexible) to supply an address to a cell that already contains a valid date value as the argument for DAY.

Author 
Dave Bruns
Related formulas 
Excel formula: Get day name from date
Get day name from date
If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date, there are several options depending on your needs. Do you want to convert the date into a day name? If you want to convert the date value to a text value, you can use the TEXT...
Excel formula: Get month from date
Get month from date
The MONTH function takes just one argument, the date from which to extract the month. In the example shown, the formula is: = MONTH ( B4 ) where B4 contains the dateJanuary 5, 2016. The MONTH function returns the number 1 representing the month(...
Excel formula: Get year from date
Get year from date
The YEAR function takes just one argument, the date from which you want to extract the year. In the example, the formula is: = YEAR ( B4 ) B4 contains a date value for January 5, 2016. The YEAR function returns the number 2016 representing the year...
Related functions 
Excel DAY function
Excel 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...

Related courses 
Core Formula

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.