Calculating date intervals

Data Analysis in Google Sheets

James Chapman

Curriculum Manager, DataCamp

Recap...

 

Extract date components:

  • YEAR()
  • MONTH()
  • WEEKDAY()
  • TEXT()

 

Extract time components:

  • HOUR()
  • MINUTE()
  • SECOND()

 

This lesson: calculate durations!

Data Analysis in Google Sheets

When is now?

 

  • Comparing to the present date

People of varying ages.

 

  • Comparing to the present time

Sprinters on the starting line.

Data Analysis in Google Sheets

TODAY()

= TODAY()

9/26/2022

 

  • Spreadsheet is refreshed...
9/27/2022
Data Analysis in Google Sheets

NOW()

= NOW()

9/26/2022 3:24:04

 

  • Spreadsheet is refreshed...
9/26/2022 4:24:04
Data Analysis in Google Sheets

Date arithmetic

 

Dates of the manned moon missions.

Data Analysis in Google Sheets

Date arithmetic

 

Dates of the manned moon missions.

Data Analysis in Google Sheets

Date arithmetic

 

Dates of the manned moon missions.

  • Subtracting dates returns the interval in days
Data Analysis in Google Sheets

Date arithmetic

 

Dates and intervals between the manned moon missions, in days.

  • Subtracting dates returns the interval in days
Data Analysis in Google Sheets

DATEDIF()

 

Syntax:

  • DATEDIF(start_date, end_date, unit)
    • end_date > start_date
    • unit: "Y", "M", "D", ...

 

Dates and intervals between the manned moon missions, in months.

Data Analysis in Google Sheets

DATEDIF()

 

Syntax:

  • DATEDIF(start_date, end_date, unit)
    • end_date > start_date
    • unit: "Y", "M", "D", ...

 

  • Results are chopped

 

Dates and intervals between the manned moon missions, in years.

Data Analysis in Google Sheets

DATEDIF() and TODAY()

 

Syntax:

  • DATEDIF(start_date, end_date, unit)
    • end_date > start_date
    • unit: "Y", "M", "D", ...

 

  • Results are chopped

 

Number of years since each moon landing.

Data Analysis in Google Sheets

DATEDIF() and TODAY()

 

Syntax:

  • DATEDIF(start_date, end_date, unit)
    • end_date > start_date
    • unit: "Y", "M", "D", ...

 

  • Results are chopped

 

Number of years since each moon landing.

Data Analysis in Google Sheets

Let's practice!

Data Analysis in Google Sheets

Preparing Video For Download...