DAY
Gives the day only from the given date
Syntax of Excel Day formula:
=DAY(serial_number)
In words:
=Just give the day from(this date)
Example of Excel Day formula
=DAY(“8/6/1986”) will give 6. Remember the date is mentioned in month/day/year format.