deepcalc
DocsDAYS360

DAYS360

View as markdown/docs/functions/days360.md Ask Claude about this pageOpens Claude with this page's address

Returns days between dates on 360-day year.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=DAYS360(DATE(2026,1,1), DATE(2026,12,31))
Result 360

Syntax

DAYS360(start_date, end_date, [method])
start_date
number required
end_date
number required
method
number optional
DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYSReturns number of days between two dates. EDATEReturns date shifted by given months.