# Get day from date

=DAY(date)

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)

### How this formula works

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.

## 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.