×
Engels
Dit artikel is niet beschikbaar in uw taal.

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

Was deze informatie nuttig?

Heel goed! Hebt u nog meer feedback?

Wat kunnen we verbeteren?

Bedankt voor uw feedback.

×