Autoplay
Autocomplete
Previous Lesson
Complete and Continue
DATE FUNCTIONS FOR DATA ANALYSIS AND MODELLING
INTRODUCTION TO THE COURSE
INTRODUCTION TO THE COURSE (2:06)
SECTION ONE - BASIC
SHORTCUTS - UNDERSTANDING HOW DATE AND TIME WORKS (9:39)
CUSTOM FORMATS USING TEXT (8:33)
CONSTRUCT AND DECONSTRUCT A DATE - DAY, MONTH, YEAR (6:07)
DIFFERENCE BETWEEN DATES - NETWORKDAYS (3:49)
CALCULATE EXPIRY DATES AND BALANCE - EOMONTH AND EDATE (10:08)
GOAL SETTING - WORKDAY (2:27)
HIGHLIGHT WEEKENDS (2:24)
SECTION TWO - ADVANCED
REPLACE POSITION OF DAY AND MONTH (1:24)
FIND WEEKENDS (1:36)
ADDING UP HOURS (1:36)
FIND DATES IN RANGE (7:49)
FIND END OF QUARTER (9:34)
FIND RETIREMENT (6:24)
FIND DIFFERENCE IN MONTHS (3:29)
FIX INCORRECT DATE (3:56)
DIFFERENCE IN DAYS, MONTHS AND YEARS (11:03)
CONVERT DATE INTO STRING (1:53)
CREATE LIST OF DATES (5:31)
CREATE LIST OF DATES WITH SINGLE FUNCTION (4:52)
SCHEDULE (4:15)
DATE PICKER ADD-IN (2:45)
SOLUTIONS
SOLUTIONS
GET YOUR CERTIFICATE
FIND DATES IN RANGE
Complete and Continue