O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Mastering Date and Time Formulas

Calculate Elapsed Days between Dates

You can easily calculate the number of days that have elapsed between two dates. Suppose you need to know the number of days a certain item was on sale to monitor sales during promotional periods. You can enter the start and end dates of each promotion, let Excel calculate the number of days for each promotional period, and then sum the promotional days.

When you enter the starting and ending dates into a worksheet, use a format that Excel recognizes as a date format. The default date format Excel recognizes and assigns to dates that you enter is the short date format, which is set up in the Windows Regional and Language Options dialog box. When your Regional and Language ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required