Page 1 of 16PREVNEXT

Figure out dates by using formulas

Figure out dates by using formulas in Excel
Learn how to figure out dates by using formulas in Microsoft® Excel.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to use formulas to find the:

  • Number of days between dates.
  • Date that falls after a number of workdays.
  • Date that falls after a number of years, months, or days.

Before you begin

You should complete the course Audio course: Get to know Excel: Enter formulas, or you should already be familiar with Excel formulas, functions, cell references, and function arguments.


How many workdays until vacation? What will be the finish date for a project? In this course you'll learn how to use formulas to find the number of days between dates. And just for fun, you'll see how to find out from today's date how many days old you are.

To learn more about this course, you can read the overview in the center of this page or the detailed table of contents in the left column. Click the Next button to start the first lesson.

Page 1 of 16PREVNEXT