Playlist Duration

Playlist · excelisfun

Excel Date Tricks

by excelisfun · 121 videos

Total watch time

15h 13m

at 1× speed · exactly 15 hours, 13 minutes, 17 seconds at 1×

At an hour a day you'd finish in 16 days

The shape of the course

121 videos in blocks of 10 · each column is a block's total, to scale

1h 51m
51m 44s
1h 10m
51m 6s
1h 21m
1h 24m
58m 3s
1h 49m
1h 55m
56m 44s
1h 16m
42m 29s
5m 59s

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

Plan to finish

About 16 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 16 days. Turn on JavaScript to plan around your week.

Videos (121)

15h 13m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
1 Highline Excel 2016 Class 09: Date Formulas and Date Functions, including Fiscal Quarter & Year 22:04 2016-05-10
2 Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples) 24:36 2010-02-09
3 Highline Excel 2013 Class Video 31: Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More 11:37 2013-11-08
4 Excel Magic Trick 783: Date Functions & Formulas (17 Examples) 19:06 2011-05-21
5 Excel Magic Trick 428: Trouble Entering Dates - Date Syntax 2:29 2009-10-26
6 Excel Magic Trick 657: EOMONTH function For Invoices, Financials, and Quarterly Reports 4:26 2010-07-17
7 Excel Magic Trick #12: Date Math! 3:45 2008-03-05
8 Excel Basics #15: Date & Time Format & Calculations 7:51 2008-12-16
9 Highline Excel Class 12: DATE functions & Formulas 9:53 2009-04-05
10 Excel Magic Trick 372: WORKDAY function - Find Date in Future 5:01 2009-08-27
11 Excel Magic Trick 300: YEAR DATE TEXT functions for Date Label 3:59 2009-03-23
12 Excel Magic Trick 427: Determine Day Name For Future Date 6:13 2009-10-26
13 Excel Magic Trick 301: 1900 Date Problems and Fixes 8:22 2009-03-23
14 Excel Magic Trick #123: Date Data Validation 3:43 2008-10-17
15 Excel Magic Trick #189: Count Days Not Sunday 5:34 2009-01-09
16 Excel Magic Trick #202: Calculate Vacation Days 4:10 2009-01-09
17 YouTubersLoveExcel#13: Date Math and IF function 6:12 2008-04-23
18 Excel Magic Trick 299: Date & Time Number - Total Days & Hours Formula 5:16 2009-03-23
19 Excel Magic Trick 310: D Functions & Date Criteria 3:02 2009-05-01
20 Excel Magic Trick 312: Extract Date & Time From Text String 5:13 2009-05-01
21 YTLE#108: Excel Number of Days In Year 4:21 2008-08-30
22 Excel Magic Trick 324: Dynamic Data Validation List of Dates 7:31 2009-05-17
23 YouTubersLoveExcel#22: EOM Terms with IF, DAY & EOMONTH fun 5:14 2008-05-30
24 Excel Magic Trick 371: Average Time Between Customer Orders AVERAGEIF & AVERAGE IF 11:27 2009-08-27
25 Excel Magic Trick 353: Date VLOOKUP for Seasons 5:01 2009-08-07
26 Excel Magic Trick 349: Automatic Dynamic Chart for Last Nine Weeks of Data 16:37 2009-07-29
27 Excel Magic Trick # 281: Formula For Vest Date 2:09 2009-03-06
28 Excel Magic Trick #141 part 1: Day Numbers to Dates 3:20 2008-10-28
29 Excel MT142 p2: Array Formula for Counting Dates 10:11 2008-10-28
30 Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria 4:29 2009-09-19
31 Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010 2:11 2009-11-02
32 Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.) 10:01 2009-11-02
33 Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays 1:45 2009-11-02
34 Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekends 4:52 2010-02-26
35 Excel Magic Trick 551: Count Mondays or Sundays or Tuesdays, etc. Between Start & End Date 7:34 2010-03-23
36 Excel Magic Trick 564: Daily Gantt Chart 8:33 2010-04-05
37 Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions 2:22 2010-04-04
38 Excel Magic Trick 579: MOD function and Date Math Each Successive Date Is Repeated Twice 2:42 2010-04-27
39 Excel Magic Trick 594: How Old Are You? DATEDIF Function 3:44 2010-05-07
40 Excel Magic Trick 720: Show Records Between 2 Dates: Filter, Logical Formula, Conditional Formatting 7:22 2010-09-09
41 Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell 7:46 2010-12-26
42 Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets 14:32 2010-12-26
43 Excel Magic Trick 767: Count Months from Start and End Date 6:55 2011-03-11
44 Excel Magic Trick 806: Schedule with Holidays Conditional Formatting & Custom Number Formatting 10:26 2011-09-27
45 Excel Magic Trick 848: Create List of Dates For Month With Formula 7:18 2011-12-21
46 Excel Magic Trick 869: Formula Calculate First Day of Week 2010 & 2003 Formula WEEKDAY Function 3:17 2012-02-24
47 Excel Magic Trick 907: How To Make Excel Calendar (4 Examples) 16:12 2012-04-13
48 Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS 4:01 2013-07-16
49 Mr Excel excelisfun Trick 138: NETWORKDAYS.INTL Amazing New "Any Weekend" Argumnet 7:52 2013-09-09
50 Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00") 3:10 2013-12-27
51 Excel Magic Trick 1076: Convert Date-Time Values to Serial Numbers w TEXT & Custom Number Format 3:36 2014-02-26
52 Mr Excel & excelisfun Trick 153: Show Day Numbers From Start & End Date: VBA or Formula? 7:33 2014-02-28
53 Excel Magic Trick 1083: SUMIFS: Add Invoice Amounts Between Start & End Dates (Adding For Period) 3:46 2014-03-13
54 Excel Magic Trick 1103: Formulas for Quarters, Fiscal Quarters & Fiscal Years 8:51 2014-04-25
55 Excel Magic Trick 1123: Dynamic Formula To Create A List of Dates For Month 4:44 2014-06-26
56 Excel Magic Trick 1124: Conditional Format Sundays & Weekends: NETWORKDAYS.INTL & NOT functions 6:05 2014-06-26
57 Excel Magic Trick 1125: Data Validation Custom Formula: Workday Dates in Current Month 8:21 2014-06-26
58 Excel Magic Trick 1126: Populate Calendar with "X" Based on Start, End, Weekend & Holiday Dates 8:30 2014-06-26
59 Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula 26:34 2014-07-13
60 Excel Magic Trick 1163: COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. 6:04 2014-12-04
61 Excel Magic Trick 1166: Count Dates From Date-Time Values: COUNTIFS or PivotTable? 5:45 2014-12-05
62 Excel Magic Trick 1195: Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? 7:45 2015-05-02
63 Excel Magic Trick 1196: YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… 9:47 2015-05-03
64 Excel Magic Trick 1239: Formula To Indicate a Date is in Leap Year 4:02 2015-10-01
65 Excel Magic Trick 1255: Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates 5:10 2016-01-16
66 Excel Magic Trick 1256: Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!! 5:15 2016-01-17
67 Excel Magic Trick 1264: Gross Pay From Start & End Date, Weekends Sun & Mon and Weekly Pay Scale 4:09 2016-01-28
68 Excel Magic Trick 1265: NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples) 7:53 2016-01-29
69 Excel Magic Trick 1266: NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule? 4:50 2016-01-30
70 Excel Magic Trick 1270: Calculate Retirement Date with EDATE and EOMONTH functions 3:27 2016-02-05
71 Excel Magic Trick 1312: Count The Number Of Mondays & Tuesdays Since Birth: NETWORKDAYS.INTL 8:25 2016-08-09
72 Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods) 26:42 2016-09-11
73 Excel Magic Trick 1389: Average Number of Days Between Two Columns of Dates 2:42 2017-03-07
74 Excel Magic Trick 1388 Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson) 12:03 2017-03-06
75 Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples 5:20 2017-03-09
76 Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description 14:48 2017-04-14
77 Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report 13:34 2017-04-15
78 Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records 5:26 2017-04-15
79 Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions 7:05 2017-04-17
80 Mr Excel & excelisfun Trick 181: Month To Date: PivotTable or Excel Formulas? 13:18 2017-04-21
81 Excel Magic Trick 1410: Calculate Closing Balance for Each Month from Balance Transaction Table 10:40 2017-04-30
82 Excel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function 10:35 2017-08-15
83 Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples) 16:08 2017-08-23
84 Excel Magic Trick 1457 Part 2: Regional Settings & Text or Number Date / Times in SUMIFS Function 3:21 2017-08-29
85 Excel Magic Trick 1466: Formulas For Start of Month & Number Days in Month From Any Date 3:16 2017-09-28
86 Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic) 37:16 2017-12-13
87 Excel Magic Trick 1512: Count Workers Employed 1 to 6 Years Based on Hire Date? 9 Examples 14:36 2018-08-10
88 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
89 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
90 Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS 7:09 2019-02-14
91 Create Column of Month End Dates in Excel - Excel Magic Trick 1556 0:54 2019-07-02
92 Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557) 1:10 2019-07-03
93 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales 4:20 2019-07-07
94 Excel Magic Trick 1560: Half Year Running Totals in PivotTable 5:32 2019-07-08
95 Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563 2:51 2019-07-15
96 Extract Date from End of Description with Excel Worksheet Formula - Excel Magic Trick 1583 1:48 2019-08-04
97 Count Number of Saturdays in Month - 5 Different Formulas!- Excel Magic Trick 1587 8:51 2019-08-11
98 excelisfun YouTube Birthday Party: 12 Years @ YouTube. Feb 15, 2008 – Feb 15, 2020. 1:11 2020-02-15
99 COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656 11:34 2020-03-29
100 Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659 18:33 2020-04-10
101 Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676 4:52 2020-07-06
102 Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677 1:51 2020-07-09
103 Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680. 6:02 2020-07-27
104 Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun 17:11 2020-08-14
105 List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688. 4:47 2020-09-09
106 List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687. 7:07 2020-09-07
107 Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689. 6:59 2020-09-11
108 Expand Years to Rows: Power Query or VBA? Dueling Excel #195 with Mr Excel & Excelisfun 8:54 2020-09-18
109 Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710 8:35 2020-12-22
110 Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767 9:49 2021-12-20
111 Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790 4:07 2022-04-16
112 Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796 7:50 2022-08-09
113 Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts 3:38 2023-01-19
114 Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 5:59 2023-07-09
115 Create Random Dates with Excel Functions. Excel Magic Trick 1894 3:22 2025-06-17
116 Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895. 1:51 2025-06-18
117 Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896 2:13 2025-06-19
118 Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897 4:40 2025-06-20
119 Extend Excel Date Format To Other Dates: Fill Formatting Only Trick! Excel Short 80 1:02 2025-12-16
120 Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920. 7:47 2025-12-23
121 Conditionally Format Row in Schedule for Today’s Date - Mixed Cell References | EMT 1924 5:59 2026-08-09
For your README

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 15h 13m · 121 videos

Markdown
[![Watch time: 15h 13m · 121 videos](https://playlistduration.com/badge/playlist/PLFBCE0BFCBBE102EA.svg)](https://playlistduration.com/playlist/PLFBCE0BFCBBE102EA)
HTML
<a href="https://playlistduration.com/playlist/PLFBCE0BFCBBE102EA"><img src="https://playlistduration.com/badge/playlist/PLFBCE0BFCBBE102EA.svg" alt="Watch time: 15h 13m · 121 videos" width="217" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLFBCE0BFCBBE102EA returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-11-07 (cached). Private or deleted videos are excluded from totals.