Explainry Tutorials to Expert in IT

DAYS function in Google Sheets

The DAYS function returns the number of days between two given dates. For examples the formula =days(“2/9/2019″,”10/8/2019”) returns 23 days.

Syntax

DAYS(end_date,start_date)

end_date – Required. The end date.

start_date – Required. The start date.

Example

The below formula shows the difference with two dates within a year.

The below formula shows the difference with two dates within two years.

The formula returns a minus sign with result if start_date is provided first in syntax instead of end_date.




Copyright © 2016 - 2020 Explainry.com | All Rights Reserved