Figure out dates by using formulas in Excel 2010

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Use formulas to figure out dates such as how many workdays until vacation, or calculate the finish date for a project.

Goals

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

  • Number of days between two dates.

  • Number of workdays between two dates.

  • Date that falls after a number of workdays.

  • Date that falls after a number of months.

  • Date that falls after years, months, and days

Before you begin

You should already be familiar with Excel formulas. If not, take Get to know Excel 2010: Create formulas before taking this course.

Download this course

Offline version (20.1 MB)

Quick reference card

See the quick reference card for a brief, printable reminder of the key points in this course.

See more courses on Microsoft Office Training.

Applies To: Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language