Author: Oscar Cronquist Article last updated on August 19, 2018

The DAY function extracts the day as a number from an Excel date.

Formula in cell C3:


Excel Function Syntax



serial_number Required. The Excel date value you want to extract the day number from.


Excel dates are actually numbers formatted as dates. January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.