How to get day of the month in Microsoft Excel / Use of DAY function (formula) in Microsoft Excel

DAY

Use of DAY function/formula in Microsoft Excel:

This function return the day of the month between 1 to 31 from given date.

Syntax/Formula:

Syntax of DAY function in Microsoft Excel is below.

=DAY("date/month/year")

Example:

Step 1: First type any date for Ex. 25-12-1955 in cell B5.

Step 2: Type formula =DAY(B5) in cell B7 and press enter.

DAY