2006-12-04 07:37:53 · 3 answers · asked by Emma C 1 in Computers & Internet ➔ Software
Use DATEDIF()
http://www.meadinkent.co.uk/xl_birthday.htm
http://www.exceltip.com/st/Calculating_Differences_Between_Dates/86.html
http://www.cpearson.com/excel/datedif.htm
2006-12-04 07:40:55 · answer #1 · answered by arus.geo 7 · 0⤊ 0⤋
put the 2 dates in 2 cells, and put A minus B in a third cell. Just format the 3rd cell (result) as number
2006-12-04 07:40:47 · answer #2 · answered by Nick B 2 · 0⤊ 0⤋
Just format the cells where your dates are as date (click on the cells, then Format=>Cells=>Number tab=>Date=>OK. Format the cell where your answer is as a number (click on the cell, then
Format=>cells=>Number tab=>Number=>Decimal Places scroll to 0=>OK). And you should be all set.
2006-12-04 07:48:08 · answer #3 · answered by Bob 3 · 1⤊ 0⤋