Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

DAY

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

Rational

Return only the day value of a date.

Description

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

Syntax

=DAY(serial_number)

Parameters

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

YEAR

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 a proportion of years for a given range of dates in Excel

YEARFRAC

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 »
Returns Nth months of a date in Excel

MONTH

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 »