Author: Oscar Cronquist Article last updated on April 07, 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.