Office.com

Sign in to Office.com

Start working in the cloud

Microsoft account

Microsoft account

Sign in with the account you use for SkyDrive, Xbox LIVE, Outlook.com, or other Microsoft services.

Organizational account

Organizational account

Sign in with the account provided by your work or school to use with Office 365 or other Microsoft services.

Submit Feedback

Skip to main content

HOME
MY OFFICE
PRODUCTS
SUPPORT
IMAGES
TEMPLATES
STORE

Search all of Office.com

Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

Page 16 of 16PREVNEXT

Learn how to figure out dates using formulas in Excel 2007

Overview

Show/Hide lesson sections

Lesson 1: What dates mean to Excel

The calendar starts in 1900

How Excel recognizes dates

Practice

Test yourself

Show/Hide lesson sections

Lesson 2: Calculate dates by using formulas

Find the number of days between two dates

Find the number of workdays between two dates

Find the date after a number of workdays

Find the date after a number of months

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

Find out how old you are today

Practice

Test yourself

Feedback

Quick reference card

Feedback

Please rate the course and give us your feedback. Ratings and feedback help us to create useful courses and to make existing ones better.

Page 16 of 16PREVNEXT

Site Directory Contact Us Submit Feedback Legal Trademarks Privacy and Cookies Accessibility

© 2013 Microsoft Corporation. All rights reserved.