0
0
Google Sheetsspreadsheet~8 mins

DATEDIF for differences in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - DATEDIF for differences
Goal

Find how many days, months, and years passed between two dates for project tracking.

Sample Data
ProjectStart DateEnd Date
Website Redesign2023-01-152023-04-20
App Launch2022-11-012023-03-15
Marketing Campaign2023-02-102023-05-05
Customer Survey2023-03-012023-03-30
Product Testing2023-01-202023-02-28
Dashboard Components
  • KPI Cards: Show total days, months, and years between start and end dates for each project.
  • Formulas:
    Days difference: =DATEDIF(B2,C2,"D")
    Months difference: =DATEDIF(B2,C2,"M")
    Years difference: =DATEDIF(B2,C2,"Y")
  • Summary Table: Shows Project, Days, Months, Years columns with formulas applied for each row.
Dashboard Layout
+---------------------------+
|       Project Dates        |
| +-----------------------+ |
| | Project | Start | End | |
| +-----------------------+ |
|                           |
| +-----------------------+ |
| | Days | Months | Years | |
| +-----------------------+ |
+---------------------------+
Interactivity

Add a filter to select a project name. When you pick a project, the Days, Months, and Years cards update to show only that project's date differences.

Self Check

If you filter to show only "App Launch", what is the number of months difference shown?

Answer: 4 months (from 2022-11-01 to 2023-03-15)

Key Result
Dashboard shows the difference in days, months, and years between project start and end dates using DATEDIF.