Excel Function

DAY

Extracts day from a date.

DAY(serial_number)

Arguments

serial_number

Required

Enter a date/reference-related value.

Practice Preview

calculate and display date/time values. Use DAY to Extracts day from a date. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=DAY(B2)

Practice This Function

Practice in Sequential Mode Back to Function List