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
