Microsoft KB Archive/27089

= XL: Calculating the Number of Days Between Two Dates =

Article ID: 27089

Article Last Modified on 8/16/2005

-

APPLIES TO


 * Microsoft Excel 3.0 Standard Edition
 * Microsoft Excel 4.0 Standard Edition
 * Microsoft Excel 4.0a
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 95a
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 3.0 for Macintosh
 * Microsoft Excel 4.0 for Macintosh
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Excel 5.0a for Macintosh
 * Microsoft Excel 98 for Macintosh

-



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 &quot;Date2&quot; represents the later of the two dates and &quot;Date1&quot; represents the earlier of the two dates.

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

Additional query words: 4.00a 5.00a 5.00c 7.00a 97 98 XL98 XL97 XL7 XL5 XL4 XL3

Keywords: kbhowto KB27089

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.