Article updated on January 16, 2018

Extracts the day as a number out of 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.