calculating time intervals in excel

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

Michael Tomasura

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