DAYS

Returns number of days between two dates.

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

Examples

=DAYS(DATE(2026,12,31), DATE(2026,1,1))

Result 364

Syntax

DAYS(end_date, start_date)

end_date: number required
start_date: number required

DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYS360Returns days between dates on 360-day year. EDATEReturns date shifted by given months.