in ,


How to Use DAYS Function in Microsoft Excel?

Usage of DAYS Function in Microsoft Excel!

DAYS Function

DAYS Function in Excel:

Here, in this article, we will explore the basic syntax and usage of the DAYS Function in Microsoft Excel.

Jump To:

What is meant by DAYS Function?

The Excel DAYS Function returns how many days between the two given dates (i.e.) end date and start date.

Primary Syntax of DAYS Function:

The Primary syntax of Excel DAYS Function is,

=DAYS(end_date, start_date)

DAYS Function – Practical Examples:

Let’s look at the examples of DAYS function and explore how it works in Microsoft Excel.

Example 1:

  • The input value is entered in the Cell C5 & Cell D5.

NOTE: In Input value, you should give the value as the Month → Date → Year format then only the DAYS Function returns the number of days between the end date and the start date.

  • The formula is entered into the output Cell F5.
  • Below screenshots are the two ways of using the formula for DAYS Function.
Formula 1
Formula 1
Formula 2
Formula 2
  • Press enter to calculate the output.

Example 2:

  • Here, the below screenshot will explain the different examples of the DAYS Function.
Example 2
Example 2

Example 3:

  • If you enter the value of the input in the wrong format, then it returned as an Error.
  • Refer to the below screenshot, the input data is entered in the way of DATE → MONTH → YEAR format. So it returns the output as an error.
  • And in the other one, the input value of the end_date is less than the start_date, so it displays the output as negative.
Example 3
Example 3


Hoping this article gave you a clear tutorial about the explanation, basic syntax, and usage of the DAYS Function in Microsoft Excel. In addition, the DAYS Function explained with some practical examples with clear cut screenshots. Kindly share your suggestions/queries in the comment box & don’t forget to drop your feedback.

Thanks for visiting TecKangaroo!! Keep Learning!!

Related Articles:

Leave a Reply

Your email address will not be published. Required fields are marked *