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 ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.