0
0
Excelspreadsheet~8 mins

DATEDIF for date differences in Excel - Dashboard Guide

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

Calculate the difference between two dates in days, months, or years to track project durations or age.

Sample Data
TaskStart DateEnd Date
Project A2023-01-152023-04-20
Project B2022-06-012023-06-01
Project C2023-03-102023-03-25
Project D2021-12-312023-01-01
Project E2023-05-052023-05-05
Dashboard Components
  • KPI Card: Total Days for Project A
    Formula: =DATEDIF(B2,C2,"d")
    Result: 95 days
  • KPI Card: Total Months for Project B
    Formula: =DATEDIF(B3,C3,"m")
    Result: 12 months
  • KPI Card: Total Years for Project D
    Formula: =DATEDIF(B5,C5,"y")
    Result: 1 year
  • Table: All Projects Duration in Days
    Formula in D2 and copied down: =DATEDIF(B2,C2,"d")
    Results:
    Project A: 95
    Project B: 365
    Project C: 15
    Project D: 366
    Project E: 0
  • Table: All Projects Duration in Months
    Formula in E2 and copied down: =DATEDIF(B2,C2,"m")
    Results:
    Project A: 3
    Project B: 12
    Project C: 0
    Project D: 12
    Project E: 0
Dashboard Layout
+----------------------+----------------------+----------------------+
| Total Days Project A  | Total Months Project B| Total Years Project D |
|      (95 days)        |      (12 months)      |       (1 year)        |
+----------------------+----------------------+----------------------+
|                      All Projects Duration Table (Days & Months)                      |
|  Task   | Start Date | End Date  | Duration (Days) | Duration (Months) |           |
+---------+------------+-----------+-----------------+-------------------+           +
Interactivity

Add a date filter to select a range of projects by start date. When you pick a date range, the duration tables and KPI cards update to show only projects starting within that range.

Self Check

If you add a filter to show only projects starting after 2023-01-01, which projects remain and what is the total duration in days for those projects?

Answer: Projects A, C, and E remain.
Total duration in days = 95 + 15 + 0 = 110 days.

Key Result
Dashboard showing project durations calculated with DATEDIF in days, months, and years.