How to use DAY Function in Excel

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.



  1. 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.

extract day number from a date using excel day function
get dynamic day number by using excel day function


  1. Excel stores date in serial number and day function will only get day number from a date with a valid serial number.
  2. It will only return day number from a date with year ranging from 1900 to 10000.
  3. You can also insert a date directly into the function by using quotation marks.

Sample File