# DAYS360

Formulas / DAYS360
Calculate 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.