View Full Version : Solved: How to get the number of days between two dates

11-05-2007, 01:04 PM
I want to calculate the number of days between two provided days.

Can anyone pls let me know how to do that.


11-05-2007, 01:20 PM
excel treat all dates as the number of days sence 1/1/1900, and all times are treated as decmels of this number. so noon today would be 39391.5. so all you have to do is take one date and subtract the other and you will get the resulting number of days. just be carful of formating. if you want to see the number of days you need to set the cell to number or general formating.

11-05-2007, 01:32 PM
All you do is subtract the dates from each other, you will then get the results. However, you need to format that cell as to be a number format. Goto FORMAT - CELLS. In the Category, select number.

11-06-2007, 04:27 PM
Thanks Guys:cloud9: