The DAY function extracts the day from a valid date.
In simple words, it returns day from a date ignoring month and year. The number of the day ranging from 1 to 31 from a date you have mentioned.
- serial_number A valid serial number of date from which you want to extract day number.
In the below example, we have used DAY function to simply get day from a date.
- Excel stores date in serial number and day function will only get day number from a date with a valid serial number.
- It will only return day number from a date with year ranging from 1900 to 10000.
- You can also insert a date directly into the function by using quotation marks.