calculating time intervals in excel

  • Thread starter Thread starter Shannon
  • Start date Start date
S

Shannon

Does anyone know how to calculate a time interval between
two dates (in separate columns) in Excel? Any help would
be greatly appreciated.
 
Cell A1= 1/1/85
Cell B1= 9/11/03

This formula =B1-A1 will equal 6827 days

Make sure the cell with the formula is formatted as a number not a date.
 
Back
Top