Excel DAY Function

HomeExcel FunctionsExcel DAY Function (Example + Sample File)


The Excel DAY Function is listed under Microsoft Excel's Date Functions category. It returns the day number from a valid date. As you know, in Excel, a date is a combination of day, month, and year, DAY function gets the day from the date and ignores the rest of the part.

How to use it

To learn how to use the DAY function in Excel, you need to understand its syntax and arguments:




  • serial_number: A valid serial number of date from which you want to extract day number.


  • It will only return day number from a date with a year ranging from 1900 to 10000.
  • You can also insert a date directly into the function by using quotation marks.


To master DAY function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used the DAY function to simply get the day from a date.

And in the below example, we have used DAY with TODAY to create a dynamic formula that returns the current day number and it will update every time you open your worksheet or when you recalculate your worksheet.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.