download sample file to learn about excel day functionExtract day number from a valid excel data with Day function.

In simple words, it will return day from a date ignoring month and year.

It will give you 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.

More Information on Excel DAY Function

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


In below example, I have used day function to get day number from a date. You can use this function when you have dates in your data & you only need day number.

Extract Day Number from a date using excel day function

And, in below example, I have used this function to create a dynamic formula which returns current day number and it will update every time you open your worksheet or when you recalculate your worksheet.

Get Dynamic Day Number By Using Excel Day Function

Sample File

download sample file to learn about excel day function

What’s Next?

To learn more about Excel DAY Function you can check Microsoft’s Help Section.

And, if you have a unique idea to use day function, I would love to hear from you.

There are also some functions like MONTH | YEAR which is highly useful like day function. Apart from this, I have a list of excel functions and some real life formulas examples.