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:

=DAY(B3)

Excel Function Syntax

DAY(serial_number)

Arguments

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

Comments

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.