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).
An Integer between 1 to 31
- 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.