Function Type: Date and Time Description: DAY function in Excel or Google Sheets converts a serial number of a date to a day of the month.It returns an integer from 1-31 as we see in calendars. You can use DAY function to get the DAY number from your TODAY function or NOW function which canContinue reading “DAY function”