Tabellab
Intermediate

Dates & Times

Build, compare, shift and format dates reliably — including the text ones that arrived from somebody else's system.

7 lessons 52 min Certificate

The first lesson is free — no account needed.

About this course

Build, compare, shift and format dates reliably, including the text dates that arrive from other systems. You learn how VBA stores dates as numbers, Date, Time and Now, DateSerial, DateAdd and DateDiff, formatting dates for people, parsing dates from text, and month ends and working days.

Lessons

  1. Date, Time and NowReading10 minFree
  2. Dates Are Really NumbersReading7 min Pro
  3. Building Dates with DateSerialReading7 min Pro
  4. DateAdd and DateDiffReading7 min Pro
  5. Formatting Dates for PeopleReading6 min Pro
  6. Parsing Dates That Arrived as TextReading8 min Pro
  7. Month Ends and Working DaysReading7 min Pro