The free guide

DAY function

Use

DAY function is used to extract a day number (1 to 31) from a date given. For example, from the given date of 12/2/2020, you may extract only the day number of “2” by using the DAY function.

Syntax

=DAY(seriel_number)

where “seriel_number” is the reference of a cell with a date in Excel format from which you want to extract a day number.

Example

Formula:

Results:

Note

Excel only handles dates after 1/1/1900.

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved