DAYS360
Formulas / DAYS360Calculate the number of days between two dates in a 360-day year.
=DAYS360(start_date, end_date, [method])
- start_date - reference to cells or values returned from functions
- end_date - reference to cells or values returned from functions
- method - [OPTIONAL] determines how the date is calculated
Examples
=DAYS360("1-Jan-2021","31-Dec-2021")The DAYS360 function can be used to calculate how many days between two dates. For example this returns 360 days.
=DAYS360("1-Jan-2021","15-Jan-2021")The DAYS360 function can also be used to calculate how many days have elapsed in a month. This example returns 15 days.
=DAYS360("1-Jan-2021","15-Feb-2021")The DAYS360 function can also be used to calculate the number of days between two dates that are in different months.This example, returns 45 days.
=DAYS360("1-Jan-2021","1-Jan-2021")The DAYS360 function can also be used to calculate the number of days between two dates that are the same. For example this formula returns 0 days.
Summary
The DAYS360 function is a Sourcetable Date/Time function used to calculate the number of days between two dates. It returns a number representing the difference between two dates.
- The DAYS360 function calculates the number of days between two dates based on a 360-day year, with twelve 30-day months.
- The DAYS360 function takes two parameters: start_date and end_date.
- The start_date and end_date parameters can be entered as either a date in the form of a number, or as a cell containing a date.
- The DAYS360 function ignores the actual number of days in months and years, which can result in discrepancies in the number of days returned.
- The DAYS360 function is useful when calculating the number of days between two dates in a legal or financial context.
Frequently Asked Questions
What is the DAYS360 function?
The DAYS360 function returns the number of days between two dates as a 360-day period. This is useful for calculating financial periods, such as the number of days in a year.
What are the arguments for the DAYS360 function?
The DAYS360 function requires two arguments: start_date and end_date. The start_date argument is required, and the end_date argument is also required. The optional method argument is a logical value and is not required.
What is the purpose of the method argument?
The method argument is a logical value and is used to determine how the DAYS360 function calculates the number of days between two dates. The value of the method argument determines whether the calculation is done according to the U.S. or European method. The default value is the U.S. method.
