Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Gives the day only from the given date
Syntax of Excel Day formula:
=Just give the day from(this date)
=DAY(“8/6/1986”) will give 6. Remember the date is mentioned in month/day/year format.