PDA

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



kbsudhir
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.

:doh:

figment
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.

JKwan
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.

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