The DAY function returns the day of the month for a given date/time value or date string.
DAY(date)
date: A date/time value or date string.
Examples
=DAY(“4/6/88 11:59:22pm”) returns 6.
=DAY(“5/12/2009”) returns 12.
