Chris: All right, welcome back everyone.
This is Section 7, Date and Time functions.
One of my favorite sections.
Hands down, one of the most important sections
in this entire training course,
simply due to the fact that
many people run into a number of issues
and headaches trying to work with dates and times in Excel.
I know I spent about a year kind of fumbling through these
not quite understanding what was going on
until I really sat down to understand how Excel is thinking
about dates and how Excel is processing dates.
And once I got that understanding,
it's actually quite simple and it made everything easier
when it came to working with dates and times.
So we're gonna start with a Date/Time 101 section
or intro where we'll talk about the date value,
which is kind of the key piece here,
and why it's gonna be your new best friend when
it comes to working with dates and times in Excel.
We're gonna talk date formatting
and then the fill series option
which is a nice little shortcut
for creating sequential dates.
We'll go into TODAY and NOW, which are volatile functions
that return the current date and the exact current time.
We'll talk YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND,
which are great ways to kind of categorize your date data.
We'll talk end of month and YEARFRAC,
go into WEEKDAY, WORKDAY, NETWORKDAYS.
Those are cool tips to kind of show how many work days fall
between two dates, what date falls a certain number
of work days from today, so on and so forth.
And then we'll finish with DATEDIF,
which is another tool to calculate differences
between two dates, and then wrap up with a very useful
hands-on demo where I'm gonna show you
how to build your own budget pacing tool
which you can customize
and transform into anything you want.
Two files for download, got our PDF
and our Section 7 Date/Time functions Excel file
which we'll be walking through.
So go ahead and download those two files.
You can print them out if you choose
and let's dive right in.