To take this course, you must be comfortable with most of Excel Course 1B

Get a handle on dates and times in Excel—without the confusion.

This course walks you through the basics like serial numbers and then dives into a variety of built-in Date and Time functions that help you work smarter with schedules, timelines, and more.

Includes:

Entering Dates and Times

Entering Dates & Times Properly
Date/Time Formats and Custom Formats
Understanding Date/Time Serial Numbers
Using Fill with Dates or Times
Today's Date (Static and Dynamic)
Current Time (Static and Dynamic)

Date Formulas/Functions

Numbers of Days or Years Between Dates
The Importance of DATE Function
YEAR, MONTH, DAY, DAYS, EDATE, EOMONTH, WEEKDAY, WEEKNUM, ISOWEEKNUM, WORKDAY, NETWORKDAYS, YEARFRAC, DATEDIF

Time Formulas / Functions

Create a Time Sheet to Calculate Hours
TIME, HOUR, MINUTE, SECOND

1303 - Excel Course 1C: Working with Dates & Times