Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Calculating the Number of Days Between Two Dates

XL2000: Calculating the Number of Days Between Two Dates

View products that this article applies to.

Summary

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB214315, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 214315
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 244