XL2000: Calculating the Number of Days Between Two Dates

This article shows you a formula that you can use in Microsoft Excel 2000 to find the number of days between two dates.

To find the number of days between two dates, you can use the following formula where "Date2" represents the later of the two dates and "Date1" represents the earlier of the two dates.

Format the cell that contains this formula as General so that the cell displays the difference between the two dates in number of days.