Functions
DAYS360
Days between dates using 360-day year
Try it
When to use it
When should I use DAYS360 instead of regular date subtraction?
Use DAYS360 when you need days between dates on a standardized 360-day year (12 months of 30 days), which is standard in bond interest and some financial calculations.
Used in
Syntax
DAYS360(start,end,[method])Examples
=DAYS360(DATE(1969,7,16),DATE(1969,7,24),1) // => 8
=DAYS360(1,270,1) // => 266
=DAYS360(DATE(2023,1,1),DATE(2023,12,31),0) // => 360