Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Excel DAYS360 function

In Excel, as a financial analyst, the DAYS360 function can help you to return the number of days between two dates based on a 360-day year, which is considered to have 30 days in each month. And the 360-day year is often used in accounting systems and financial markets.


 Syntax:

The syntax for the DAYS360 function in Excel is:

= DAYS360 ( Start_date , End_date , Method )

 Arguments:

  • Start_Date, End_Date: The two dates to calculate the number of days between.
  • Method: Optional. A Boolean value specifies whether to use the U.S. or European method in the calculation.
Method Defined
False or omitted US method. If the start date is the last day of the month, it becomes equal to the 30th day of the same month. If the end date is the last day of the month, and the start date is earlier than the 30th day of a month, the end date becomes equal to the 1st day of the next month; Otherwise, the end date is set to the 30th of the same month.
True European method. Start dates and end dates that occur on the 31st day of a month become equal to the 30th day of the same month. If the end date is last day of February, the actual date is used.

 Return:

Return the number of days between 2 dates in a 360-day year.


 Usage:

  • To get the days between two dates based on 360-day year with US method:

Please enter any one of the following formula to get the calculated result as following screenshot shown:

=DAYS360(A2,B2,FALSE)
=DAYS360(A2,B2)

doc days360 function 1


  • To get the days between two dates based on 360-day year with European method:

Please apply the below formula to return the number of days between two dates based on the European method:

=DAYS360(A2,B2,TRUE)

doc days360 function 2

Note: In the above formula, A2 is the start date, and B2 is the end date.

Tips: You can also replace the cell references in the above formulas with the date text string, such as:

=DAYS360("2018/5/10","2018/12/19", TRUE)
=DAYS360("2018/5/10","2018/12/19", FALSE)

Excel Productivity Tools

300 Advanced Features Help You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) and save 70% time.

  • Designed for 1500 work scenarios, helps you solve 80% Excel problems.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years.

Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Office Tab Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.