Excel
DAYS360 function in Excel
Calculates the number of days between two dates based on a 360-day year
=DAYS360(start_date, end_date, [method])DAYS360 syntax and parameters
Three arguments, two required.
- start_dateanyRequired
- end_dateanyRequired
- methodbooleanOptional
A logical value that specifies whether to use the U.S. or European method in the calculation.
DAYS360 examples
Formulas you'll actually reuse.
Days on a 30/360 bond-market calendar (US method) — every month counts 30:
=DAYS360(DATE(2026, 2, 28), DATE(2026, 3, 31))Result
33The European variant caps the 31st at 30 on both ends:
=DAYS360(DATE(2026, 2, 28), DATE(2026, 3, 31), TRUE)Result
32
DAYS360 in Google Sheets
Same name — your formula ports as-is.
Try DAYS360 in the playground
Edit the example — nothing to install.
Preloaded with the DAYS360 formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- DATEReturns the serial number of a particular dateDateGoogle Sheets
- DATEDIFCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.DateGoogle Sheets
- DATEVALUEConverts a date in the form of text to a serial numberDateGoogle Sheets
- DAYConverts a serial number to a day of the monthDateGoogle Sheets
- DAYSReturns the number of days between two datesDateGoogle Sheets
- EDATEReturns the serial number of the date that is the indicated number of months before or after the start dateDateGoogle Sheets