Return only the day value of a date in Excel
Converts a serial number to a day of the month


Return only the day value of a date.


The Excel DAY function returns an integer value that represents the day element of a date. Example; to extract day component from ‘08-08-2017’, use =DAY(“08-08-2017”) that returns ‘8’.




serial_number – A valid argument date (string date).

Return Value

An Integer between 1 to 31

Key Notes

  • The DAY function argument accepts date and strings (enclosed in the double quote) both.
  • If Excel does not recognize the date automatically consider using DATE function along with DAY function.
  • Excel accepts two different Date System, return #VALUE! error in case you enter a date before January 01, 1900 for Windows and January 1, 1904 for Macintosh.
To return only day part of a date we can use DAY function in Excel.  

Keep Reading Similar Functions:

Returns the Year component of a given date in Excel


The YEAR function extracts the Year component of a given date. Example; to get or find Year from a date (11/08/2017- cell B5), use =YEAR(B5), returns ‘2017’.

Read More »
Returns Nth months of a date in Excel


The MONTH function extracts an integer between 1 and 12. I.e., to get month component of a date (8/15/2017) in cell B5, use =MONTH(B5) that returns ‘8’.

Read More »
Returns a proportion of years for a given range of dates in Excel


The YEARFRAC function finds the fraction of years between two dates, like 01-01-2017 and 30-09-2017, use =YEARFRAC(startdate,enddate,2), that returns ‘0.755’.

Read More »