How to Calculate the time between two dates in Excel

June 23, 2009 by admin  
Filed under MS Office Tips & Tricks

To calculate days between 2 dates:


Enter the dates in separate cells. Then in a blank cell enter a formula to subtract one date from the other. Endure that the cell containing the formula is formatted to number. For example, enter today’s date and your date of birth to see how many days you have been on this planet!

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!