Practice free

DAY function

DAY pulls the day of the month, from 1 to 31, out of a date. It is often paired with MONTH and YEAR when splitting or regrouping dates.

Example

Read it as a sentence: turn 2024, 3, 15 into a date, then pull out the day of the month, which gives 15.

Practice this in the app

Syntax

DAY(serial_number)

serial_number (required)
A date or date serial number.

Returns: The day of the month, 1 to 31.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=DAY(46031) 9 Serial
=DAY("1/9/2026") 9 Text date
=DAY(0) 0 Serial 0
=DAY(60) 29 Serial 60 (1900-02-29)
=DAY(46031.9) 9 Fractional serial
=DAY(2958465) 31 9999-12-31
=DAY(-1) #NUM! Negative serial
=DAY(2958466) #NUM! Past 9999-12-31

Watch out for

  • Text that looks like a date is accepted but depends on regional settings.
  • Not the day of the week; use WEEKDAY for that.

Where it works

Excel
DAY is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .