Formulas > =DAY()

How To Use DAY() Function in Google Sheets


Returns the day of the month that a specific date falls on, in numeric format.

Common Questions about the DAY Formula:
1. What does the DAY formula do?
2. How do I use the DAY formula?
3. What date format should I use to apply the DAY formula?

How to Use the DAY Formula Appropriately:
1. Enter your date in cell A1 in a valid Excel format (YYYY-MM-DD).
2. Select cell B1
3. Enter the formula =DAY(A1)
4. Press enter

How the DAY Formula Can Be Commonly Mistyped:
1. Using the DAY() formula without inserting a valid date.
2. Omitting parentheses when entering the formula.

Common Ways of Using the DAY Formula Inappropriately:
1. Using the DAY() formula on a string of text.
2. Using the DAY formula on an invalid date format.

Common Pitfalls When Using the DAY Formula:
1. Not putting the date in the proper date format.
2. Using the wrong syntax or leaving out necessary parentheses when entering the formula.

Common Mistakes When Using the DAY Formula:
1. Ignoring the numeric output of the formula.
2. Not converting the output of the DAY formula into a textual format.

Common Misconceptions People Might Have With the DAY Formula:
1. That the DAY formula only works for specific dates.
2. That the output of the DAY formula won't be accurate for dates that are entered in a different format.

How To Actually Use DAY() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the DAY() formula:

Date Functions

Discover basic date functions. Select the HD quality option for the best full-screen viewing experience. Visit for more videos and tutorials!

Generate a DAY() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.