# How to Use Excel DAYS Function?

DAYS Function in Excel: Generally, Days refer to all weekdays such as Sunday to Saturday. Excel consists of a function called DAYS which is used to find the number of days between two dates. In case, you want to use the Excel DAYS function, then we will help you. It is one of the built-in functions in Excel. Anyone can use this function because it is easy to understand.

In this article, we will explain to you the Usage of the DAYS Function in Excel with practical examples. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Explanation of DAYS Function

• It is one of the built-in functions in Microsoft Excel.
• The Excel DAYS function returns the number of days between the given two dates.

## Syntax

• Here, you will see the syntax of the DAYS function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=DAYS(End_Date,Start_Date)

### Arguments Explanation:

• End-Date – Represents the end date.
• Start_Date – It refers to the given start date.

## Related examples:

Check out the following examples of the DAYS function in order to know how it works on the Excel spreadsheet.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have given the Start and End dates in cells B3 and C3 respectively.
• Then, we will apply the DAYS function to get the in-between number of days between the given two dates.
• Once you apply the above-given formula, you have to click on the button.
• After executing the formula, you will get the result, as shown in the below image.
• Let’s see another example to make it clear. In the following image, you will see some set of input dates in the range B3:C5.
• After applying the DAYS function, you will get the output as shown in the below screenshot.