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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate average in intervals 1
Turning off automatic calculation 0
Calculation Based on Dynamic Variables (What-if Scenario) 0
Interval between now and next birthday 3
Calculate the median value before a specified list 0
INDEX MATCH SMALL 13
Adding Periods at Specified intervals 6
Date Intervals 1

Top