WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » DAY Excel Function

DAY Excel Function

DAY Function in Excel

DAY function in excel is a date function in excel which is used to calculate the day value from a given date, this function takes a date as an argument and returns a two-digit numeric value as integer value which represents the day of the given date, the method to use this function is as follows =Edate (Serial Number ), the range for the output for this formula is from 1-31 as this the range of the dates in excel date format.

Syntax

DAY Formula

  • Date_value/serial_number : A valid excel date with the format of the serial number for returning the day of the month.
  • Return Value: The return value will be a numeric value between 1 and 31, which represents the day component in a date.

Usage Notes

  • The date entered in the DAY formula must be a valid Excel date in the serial number format. For example, the date to be entered is Jan 1, 2000. This is equal to the serial number 32526 in Microsoft Excel.
  • You should also note that Microsoft Excel can only handle dates after 1/1/1900.
  • DAY formula in excel is helpful in financial modeling in many business models.

How to Open DAY Function in Excel?

  1. You can simply enter the desired DAY formula in excel in the required cell to attain a return value on the argument.
  2. You can manually open the day formula in the excel dialogue box in the spreadsheet and enter the logical values to attain a return value.
  3. Consider the screenshot below to see the DAY formula in excel under the Date & Time Function menu.

DAY Function in excel - step 1

  1. Click on the DAY function excel, and the dialogue box will open, where you can enter the arguments to attain a return value, i.e., the day of the given specific date in this case.

DAY Function in excel - step 2

Let’s look below at some of the examples of the DAY function. These examples will help you in exploring the use of the DAY function in Excel.

You can download this DAY Function Excel Template here – DAY Function Excel Template

DAY Function example

Based on the above Excel spreadsheet, let’s consider three examples and see the DAY Formula return based on the syntax of the function.

DAY Function example 1

Consider the below screenshots of the above examples for clear understanding.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #1

DAY Example 1

Example #2

Example 2

Example #3

Example 3

Example #4

Example 4

Example #5

Example 5

Applications

The Microsoft DAY Function can be used for various purposes and applications within the spreadsheet. Some of the common applications of DAY Function in spreadsheets are given below –

  • Getting a series of dates by year
  • Adding years to date
  • Getting a series of dates by month
  • Getting a day from the date
  • Adding days to a specific date
  • Getting the first day of the month

Common Problem

Sometimes, you can face a problem that the result of the DAY Function is not an integer value between 1 and 31, but it looks like a date. This problem can arise when the cell or column is formatted as a ‘date’ instead of ‘general.’ You have to format the cell or column as ‘General.’

Errors

If you get any kind of error from the DAY Function, then it can be any one of the following –

  • #NUM! – This kind of error occurs in the DAY function when the supplied argument is a numeric value, but it is not recognized as a valid date.
  • #VALUE! – This kind of error occurs in the DAY function when the supplied argument is a text value and cannot be considered as a valid date.

DAY Excel Function Video

Recommended Articles

This has been a guide to the DAY Excel Function. Here we discuss the DAY Formula in excel and how to use it along with examples and a downloadable template. You may also look at these useful functions in excel –

  • WEEKDAY Excel Function
  • TODAY Function in Excel
  • NOW In Excel
  • TIME in Excel
  • Recover Document in Excel
2 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download DAY Function Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More