How to Calculate Days by Subtracting Two Dates in Excel


One of the many features of Microsoft Excel 2010 is the ability to calculate the number of days between two dates. This is useful if you want a quick and simple way to determine the number of days that have elapsed between two events. For example, if you operate a business and want to know how many days have passed since you mailed an invoice, you can use this function. The method, moreover, does not require the memorization of any complicated formulas. You can accomplish this calculation with a few mouse clicks and keystrokes.

Things You'll Need

  • Microsoft Excel 2010
  • Launch Microsoft Excel and open a new worksheet. Type the date in one cell. For example, type "1/1/2010" in cell A1.

  • Type your first date in cell A1. For example, input the date "1/1/2010."

  • Type your second date in cell B1. For example, input the date "3/14/2011."

  • Select the cell C1, type "=" and click the date in cell B1. Then type "-", click the first date and press "Enter." Cell C1 now shows 438, the number of days between the two dates you input.

Related Searches


Promoted By Zergnet



  • "Microsoft Excel 2010 In Depth"; Bill Jelen; 2010
  • "Formulas and Functions: Microsoft Excel 2010"; Paul McFedries; 2010

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!