how do i calculate the deference in dates in numbers on excel sheet. eg. 4/12/06-20/11/06=14days?

0 ⤊

how do i calculate the deference in dates in numbers on excel sheet. eg. 4/12/06-20/11/06=14days?

2006-12-04 06:47:00 · 2 answers · asked by Emma C 1 in Science & Mathematics ➔ Mathematics

2 answers

Assuming you have each date in a separate cell, all you have to do is subtract one date from the other. Then all you have to do is change the format of the new cell from "date" to "general."

2006-12-04 07:06:32 · answer #1 · answered by fingers12345 1 · 0⤊ 0⤋

It might be better to post this in the computer section.

2006-12-04 15:29:56 · answer #2 · answered by modulo_function 7 · 0⤊ 0⤋