Count number of days between dates in Excel and Google Sheets

=(A3-A2)

=DAYS(A3,A2)

A3 = end_date; A2 = start_date

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Count number of days between dates in Excel

How to count the number of days between dates in Excel?
Count number of days between dates in Excel

COUNT NUMBER OF DAYS BETWEEN DATES — EXCEL FORMULA AND EXAMPLE

Count number of days between dates in Google Sheets

How to count the number of days between dates in Google Sheets?
Count number of days between dates in Google Sheets

COUNT NUMBER OF DAYS BETWEEN DATES — GOOGLE SHEETS FORMULA AND EXAMPLE