How to substract Dates in excel?

0 ⤊

Ex:
Date resigned 26.07.2006
Date Joined 30.10.1995
No of Years DD M YY

Please show how to get the answer in excel with formulas

2006-07-26 07:35:56 · 3 answers · asked by maxy 1 in Business & Finance ➔ Investing

If you need to have both dates included then you have to use the formula Cell1 - Cell2 + 1

2006-07-28 15:43:15 · answer #1 · answered by Dilip Rao 3 · 0⤊ 0⤋

="7/26/2006"-"10/30/1995"

The answer is 10 years, 9 months, and 26 days.

2006-07-26 07:40:24 · answer #2 · answered by NC 7 · 0⤊ 0⤋

it is easy
=cell1-cell2
it will give you the number of days positive or negative

2006-07-26 07:43:12 · answer #3 · answered by rayce92 2 · 0⤊ 0⤋