Chapter 12. 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 that you need to know the number of days a certain item was on sale during the year 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 that 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. ...
Get Master Visually®: Excel® 2007 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
