City of St. Catharines Learning & Development

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