DAYS360 Function in Excel

Question

What is the DAY360 function in Excel?

Answer

The DAYS360 function, one of Excel's Date and Time functions, can be used in accounting systems to calculate the number of days between two dates based on a 360-day year (twelve 30-day months).  The syntax for the DAYS360 function is: = DAYS360 ( Start_date , End_date , Method )

  • Start_date - the start date of the chosen time period.
  • End_date - the end date of the chosen time period.  

Method - A Boolean value (TRUE or FALSE).

  • If TRUE -- the function uses the U.S. method of calculating start and end dates.
  • If FALSE -- the function uses the European method of calculating start and end dates.

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request

Details

Article ID: 7941
Created
Thu 12/29/22 1:30 PM
Modified
Fri 11/3/23 3:58 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.