Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Learn how to figure out dates using formulas in Excel 2007 
 
  Overview  
 Show/Hide lesson sections Lesson 1: What dates mean to Excel
 Show/Hide lesson sections Lesson 2: Calculate dates by using formulas
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Overview
A conceptual view of Excel  

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

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 30–40 minutes
  

Next

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.
  
ABOUT THIS COURSE

This course includes:

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

How many workdays until vacation? What's the finish date for a project? In this course, we'll show you how to use formulas to find the number of days between dates. You can calculate pretty much anything using these formulas — and we'll even show you how to determine how many days old you are.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

  
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.
  Go to previous page (disabled)    Next Go to next page
advertisement