DAYS360
Calculates the number of days between two dates based on a 360-day year.
Date & TimeDates & Time Calculations
What it does
Calculates days between dates assuming a 360-day year (12 months of 30 days).
Syntax
DAYS360(start_date, end_date, [method])
Arguments
start_date(date) — Start date.end_date(date) — End date.method(logical) — FALSE=US (NASD), TRUE=European.
Examples
360-Day Year Diff
Calculate difference.
FORMULA
=DAYS360(A2, B2)
RESULT
360
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Start | End |
| 2 | 2023-01-01 | 2024-01-01 |