How to get number of days between tow dates in Microsoft Excel / How to use of DAYS360 Function (Formula) in Microsoft Excel

DAYS360

USE OF DAYS360 FUNCTION/FORMULA in Microsoft Excel:

This function in Microsoft Excel returns the number of days between two dates based on 360 day in years.

Syntax/Formula:

Syntax of DAYS360 in Microsoft Excel is below.

=DAYS360(start_date,end_date,[method])

Example 1:

Step 1: First type any date for Ex. 25-12-1955 in cell B4 and 25-11-1956 in cell B5 as per shown in below image.

Step 2: Type formula =DAYS360(B4,B5) in cell B7 and press enter.

DAYS360

Example 2:

Step 1: First type any date for Ex. 25-12-1955 in cell B5 and 25-12-1955 in cell B6 as per shown in below image.

Step 2: Type formula =DAYS360(B5,B6) in cell B8 and press enter.

DAYS360