EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips DAY Formula in Excel

DAY Formula in Excel

By Madhuri ThakurMadhuri Thakur

day formula in excel

DAY Formula in Excel (Table of Contents)

  • DAY Formula in Excel
  • How to Use DAY Formula in Excel?

Introduction to DAY Formula in Excel

MS Excel provides several inbuilt functions; one of them is the user gives the DAY Formula, which is used to find the day of the month or date. It will return an integer value from 1 to 31. It belongs to the date and time function category in MS Excel. A user can use this function with other formulas and functions. It can be used in the worksheet formula as well as the VBA.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

For example, if a user is given a date of 22nd May 2019 as input in the DAY, it will return 22, which is the 22nd May month.

Syntax

DAY () – It will return an integer value from 1 to 31, which represents the day of the month. There is only one parameter – serial_number.

day formula syntax

The Argument in DAY Function:

serial_number: It is a mandatory parameter from where a user wants to get the day of the month.

How to Use DAY Formula in Excel?

DAY Formula is very simple and easy to use in Excel. Let’s get some examples of how to use DAY Formula in Excel.

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

Example #1 – Basic DAY Formula in Excel

A shopkeeper has few Dates; He wants to get the day of the month. Let’s see how the DAY formula can solve his problem.

Open MS Excel and go to sheet1, where the user wants to display the day of the month.

day in excel 1-1

Create one column header for the day of the month to show the function result in column B.

day excel 1-2

Click on cell B2 and apply the DAY formula.

day excel 1-3

Now it will ask for serial_number and select the date from where the user wants to see the day of the month, which is available in A2.

day excel 1-4

Press the Enter Key.

day excel 1-5

Drag the same formula to the other cells of column B to find out the month’s day.

day in excel 1-6

Summary of Example 1: As the user wants to find out the day of the month from the date by using the DAY formula, we have achieved the output. Which is displaying in column C.

Example #2 – Day of the Month from a Column Data

A company owner has personal details of his Employee where the Employee name, Airport city, Departure Date, and time are given. He wants to get the day of that month for the Departure Date.

Let’s see how the DAY function can solve his problem.

Open MS Excel and go to sheet2, where the user wants to display the day of the month from the Departure Date.

day example 2-1

Create one column header for the day of the month to show the function result in column D.

day example 2-2

Click on cell D2 and apply the DAY formula.

day example 2-3

Now it will ask for serial_number; select the Departure date from where a company owner wants to see the day of the month, which is available in cell D2.

day example 2-4

Press the Enter Key.

day example 2-5

Drag the same formula to the other cells of column D to find out the month’s day.

day example 2-6

Summary of Example 2: As the company owner wants to find out the day of the month from the Departure Date by using the DAY function, we have achieved the output. Here, the result is available between 1 to 31 in column F.

Example #3 – Another Formula for Employee Details

A company owner has personal details of his Employee where the Employee name, Current Retirement Date, and Extended Year in the retirement are given. He wants to get the new retirement date.

Let’s see how the DAY function can solve his problem. Open MS Excel and go to sheet3, where the user wants to display the new retirement date.

day in excel 3-1 

Create one column header for the day of the month to show the function result in column D.

day in excel 3-2

Click on cell D2 and apply the DATE Formula.

day in excel 3-3

Now it will ask for the month and the day.

day in excel 3-4

Press the Enter Key.

day in excel 3-5

Apply the same formula to column D to find out the new retirement date.

day in excel 3-5

Drag the same formula to the other cells of column D to find out the new retirement date.

day in excel 3-6

Summary of Example 3: As the company owner wants to find out the new retirement date after extended years in the older retirement date, the user has achieved this by using the date, Year, Month, and DAY formula together.

Things to Remember About DAY Formula in Excel

  1. The DAY function will return an integer value from 1 to 31. A user can use this function with other formulas and functions.
  2. In MS Excel, data is used to save as sequential serial numbers so that it can be used in calculations; as an example, 1st January 1900 was saved as serial number 1st and 3rd January 2008 was saved as serial number 39,450 in MS Excel, which is 39,448 days after 1st January 1900.
  3. The Day function belongs to the date and time function category in MS Excel.
  4. The given input in the DAY formula must be a valid date. You can use it in both the worksheet formula and VBA.
  5. If the serial number is a text value, it will throw an # VALUE!
  6. Users often face errors because of formatting issues in MS Excel, so they always prefer to select General in the home setting.

Recommended Articles

This has been a guide to DAY Formula in Excel. Here we discuss How to use DAY Formula in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. WORKDAY Excel Function
  2. TODAY Excel Function
  3. WEEKDAY Formula in Excel
  4. TODAY Formula in Excel
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
3000+ Hours of HD Videos
149 Learning Paths
600+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
All in One Excel VBA Bundle500+ Hours of HD Videos | 15 Learning Paths | 120+ Courses | Verifiable Certificate of Completion | Lifetime Access
Financial Analyst Masters Training Program1000+ Hours of HD Videos | 43 Learning Paths | 250+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

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

Download DAY Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download DAY Formula Excel Template

EDUCBA

डाउनलोड DAY Formula Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more