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