google sheets calculate difference between two dates in days code example

Example 1: Google Sheets How to Count business Days Between Two Dates

# Basic syntax:
=NETWORKDAYS(start_date, end_date)

# Example:
=NETWORKDAYS("12/01/2019", "02/07/2020")

Example 2: Google Sheets How to Count the Days Between Two Dates

# Basic syntax:
=DAYS("end_date", "start_date")

# Example:
=DAYS("01/01/2019","01/01/2018")

# Note, use =NETWORKDAYS for business days