In the previous post, we saw ‘Date & Time Function | How to Use the Excel Month Function?‘, now we will learn about ‘How to Use the Excel DAYS Function’.
Where to Find Date & Time Function?
To find the Date & Time function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Date & Time’ option as shown below:
What is Excel DAYS Function?
The Excel DAYS function returns the number of days between two dates.
Syntax
DAYS(end_date, start_date)
Arguments
The DAYS function syntax has the following arguments.
End_date:
Required. Start_date and End_date are the two dates between which you want to know the number of days.
Start_date:
Required. Start_date and End_date are the two dates between which you want to know the number of days.
Note:
1. Both the arguments are mandatory.
2. Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, Jan 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39447 days after January 1, 1900.
Understand With Example
In the above image you can see that the formula can be inserted in two ways:
One select the cell reference like =DAYS(B5,C5)
Second way type the end date and start date within the formula like this
=DAYS(“01/01/2021″, ” 01/01/2020″)
In this way you can calculate the number of days between two dates.
For Latest Updates & Learning Join Our YouTube Channel: Join Now
