×
Englisch
Dieser Artikel ist leider nicht in Ihrer Sprache verfügbar.

Learn how to figure out dates using formulas in Excel 2007

A conceptual view of Excel

Use formulas in your Microsoft Excel spreadsheet to figure out dates.

Start course button

About this course

This course includes:

  • Two practice sessions for hands-on experience. Practices require Microsoft Excel 2007.

  • 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.

  • Determine the date that falls after a number of workdays.

  • Find a date that falls after a number of years, months, or days.

Before you begin

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

Topics in this course

Lesson 1

Lesson 2

  1. Lesson 1: What dates mean to Excel

  2. The calendar starts in 1900

  3. How Excel recognizes dates

  4. Practice

  1. Lesson 2: Calculate dates by using formulas

  2. Find the number of days between two dates

  3. Find the number of workdays between two dates

  4. Find the date after a number of workdays

  5. Find the date after a number of months

  6. Find the date after a number of years, months, and days

  7. Find out how old you are today

  8. Practice

  9. Quick reference card

War diese Information hilfreich?

Sehr gut. Noch anderes Feedback?

Was können wir verbessern?

Vielen Dank für Ihr Feedback!

×