INTRODUCTION
DAYS function comes under the DATE AND TIME FUNCTIONS category in Excel.
Handling the dates in Excel is a challenging task, but we have many functions which help us in managing the dates well.
Out of many situations which we get stuck in while managing the dates is to find out the number of days between two dates.
For this problem, we have got the direct function DAYS which help us to find out the number of days between the two given dates.
DAYS FUNCTION FINDS OUT THE NUMBER OF DAYS BETWEEN THE TWO GIVEN DATES.
In this article, we’ll learn about the days function, its syntax formula and learn it using the examples.
PURPOSE OF DAYS FUNCTION IN EXCEL
DAYS FUNCTION RETURNS THE NUMBER OF DAYS BETWEEN THE TWO GIVEN DATES.
This function can be used in many practical situations such as
- Simply find out the days between two given dates.
- Difference between two dates.
- Calculate the weeks between two dates and
many more.
and many more.
PREREQUISITES TO LEARN DAYS FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
Helpful links for the prerequisites mentioned above What Excel does? How to use formula in Excel?
SYNTAX: DAYS FUNCTION
The Syntax for the function is
=DAYS( END DATE, START DATE)
END DATE is the ending date in the calculation of the number of days between the given two dates.
START DATE is the starting date.
IT can also be done if we enter DATE by DATE FUNCTION.
EXAMPLES:
EXAMPLE 1: FIND OUT THE NUMBER OF DAYS BETWEEN THE GIVEN DATES
DATA SAMPLE
We have two cells containing the simple dates in the standard format.
FOLLOW THE STEPS TO FIND OUT THE NUMBER OF DAYS BETWEEN THE TWO GIVEN DATES
- Double click the cells where you want to get the result.
- Enter the formula as =DAYS( END DATE, STARTING DATE ).
- For our example, we’ll use the formula as =DAYS(E7,G7) where E7 contains the ending date and G7 contains the starting date. [ HAVE A LOOK AT THE PICTURE BELOW ].
- Press Enter.
- The result will appear.
- The following picture shows the example discussed.
EXAMPLE 2: FIND OUT THE NUMBER OF DAYS THE CURRENT DAY AND ANY GIVEN DATE
DATA SAMPLE
We’ll find out the number of days between any given date and the current day.
FOLLOW THE STEPS TO FIND OUT THE NUMBER OF DAYS BETWEEN THE CURRENT DAY AND A GIVEN DATE
- Double click the cells where you want to get the result.
- Enter the formula as =DAYS( END DATE, STARTING DATE ).
- For our example, we’ll use the formula as =DAYS(TODAY(),G10) where TODAY() function will get the current day and G10 contains the other date. [ HAVE A LOOK AT THE PICTURE BELOW ].
- Press Enter.
- The result will appear.
- The following picture shows the example discussed.
In this article , we learnt the ways to use DAYS FUNCTION to get the number of days between the two given dates.