Working with Dates || Excel VBA Master Class || 3.4e

Dates are tricky to deal with in VBA. In this video, we will deep dive into the date data type and look at ways to manipulate dates accurately using various functions.

In this lesson, we will cover a lot of examples that we will help us:
- Find the current date and time using Date(), Now(), Time()
- Extract date component from a datetime value using DateValue()
- Construct a date using time intervals such as year, month and day using DateSerial()
- Extract parts of a date such as Year, Quarter etc. using DatePart()
- Add and subtract dates using DateAdd()
- Find the difference between 2 dates using DateDiff()
- Find the Weekday value of a day using Weekday() and WeekdayName()
etc.

#vba #excel

Follow the rest of the series, in the below playlist:

Code snippets can be found here:

00:00 Intro
00:57 Practice the Basics
06:00 DateSerial
09:33 DatePart
10:13 DateAdd and DateDiff
11:50 Weekday
13:52 Format
16:52 IsDate