Back to guides
Excel Formulas

DAY Function in Excel: Explained

In this article, you will learn how to use the DAY formula in Excel.


What is the DAY formula in Excel?

The DAY function in Excel is used to extract the day of the month from a date value. It is a useful tool for working with dates in Excel and can help to simplify a variety of tasks where the day information is useful.


When is the DAY function beneficial in Excel?

The DAY formula in Excel is used in multiple scenarios, please see below for some common uses of the DAY function:

  1. Date analysis: When working with large datasets that include date information, the DAY function can help to isolate specific days of the month for analysis. This can be helpful when working with deadlines or other time-sensitive tasks.
  2. Conditional formatting: You can use the DAY function as part of a conditional formatting formula to highlight cells that contain a specific day of the month.
  3. Creating custom date formats: By combining the DAY function with other date functions (such as MONTH and YEAR), you can create custom date formats to suit your needs.
  4. Data entry: When entering dates manually, the DAY function can help to ensure that the day portion of the date is entered correctly. You can use data validation rules to limit input to a valid day value (1-31).

How to use the DAY formula in Excel

  1. Select the cell where you want to display the day.
  2. Type the following formula into the cell: =DAY(
  3. Enter the cell reference or date value after the open parenthesis and then close the parenthesis.
  4. The cell should now display the day value from the input.



where input is the date from which you want to extract the day.

See below for how the formula is used:

How to use the DAY function in Excel 

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

 You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below