Microsoft KB Archive/214315

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

Article ID: 214315

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214315





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



MORE INFORMATION
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 that the cell displays the difference between the two dates in number of days.

Additional query words: XL2000

Keywords: kbhowto kbinfo KB214315

-

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

© Microsoft Corporation. All rights reserved.