DAYS360

Definition: DAYS360 is a function that returns the number of days between two dates based on a 360-day year.

Syntax: =DAYS360(start_date, end_date, [method])

Situation: This formula is suitable when you need to calculate the number of days between two dates based on a 360-day year.

Example: If you have a start date January 1, 2021 and an end date December 31, 2021, the number of days between the two dates based on a 360-day year can be found using the formula =DAYS360(“1/1/2021”, “12/31/2021”), which returns 360.