Arrow left
Back to guides
Google Sheets Formulas

DAY Function in Google Sheets: Explained

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

What does the DAY Function do in Google Sheets?

The DAY function returns the day from a given date. The DAY function is beneficial when extracting the day from a specific date. For instance, the DAY formula is helpful when you need to know the revenue per day in a month for three months, regardless of the month.

How to use the DAY formula in Google Sheets

  1. Type “=DAY” or go to “Insert”“Function” (or directly navigate to the “Functions” icon)  “Date”“DAY”.
  2. Input a date manually or refer to a cell containing a date.
  3. Press the “Enter” key.
How to insert the DAY formulas from the menu bar in Google Sheets

The general syntax is as follows:


Date: the date from which the formula pulls out the day

Imagine that you look at your revenue record containing date information and want to know which day you recorded each revenue. Look at the following screenshot to understand how the DAY function works in Google Sheets.

How the DAY function works in Google Sheets

As you can see, the formula is simple. The DAY function needs only one argument: a date or a cell reference to a cell containing a date. In the example above, the DAY function in cell E3 refers to cell D3 containing “11/5/2022”; thus, the formula returns “5”. You can use this information in column E for various purposes. For example, you can count the number of deals each day by using the COUNTIF or the COUNTIFS functions or sum up the revenue on each day by the client with the SUMIF or SUMIFS functions. If you are interested in the SUMIF, SUMIFS, COUNTIF, or COUNTIFS functions, check these articles: How to Use SUMIF Function in Google Sheets / SUMIFS Function in Google Sheets: Explained / How to Use COUNTIF Function in Google Sheets / How to Use COUNTIFS function in Google Sheets

How do I make text in a day in Google Sheets?

To learn text formatting and how to make text in a day, go to this webpage explaining the TEXT function: TEXT Function in Google Sheets: Explained

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

Automate financial reporting with LiveFlow

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