XL2000: Calculating the Number of Days Between Two Dates (214315)


The information in this article applies to:

  • Microsoft Excel 2000
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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbhowto kbinfo KB214315
©2003 Microsoft Corporation. All rights reserved.