XL: Calculating the Number of Days Between Two Dates (27089)
The information in this article applies to:
- Microsoft Excel for Windows 3.0
- Microsoft Excel for Windows 4.0
- Microsoft Excel for Windows 4.0a
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel 97 for Windows
- Microsoft Excel for the Macintosh 3.0
- Microsoft Excel for the Macintosh 4.0
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q27089
In Microsoft Excel, to find the number of days between two dates, you can
use the following formula
=Date2-Date1
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 the cell
displays the difference between the two dates in number of days.
| Modification Type: | Minor | Last Reviewed: | 8/16/2005 |
|---|
| Keywords: | kbhowto KB27089 |
|---|
|