How to subtract two dates

Closed
Report
-
Posts
11
Registration date
Wednesday September 16, 2009
Status
Member
Last seen
June 16, 2011
-
Hello,
I want to subtract Dates in 1 column from Dates in other column

eg: 25.05.2010 - 02.05.2010 = Answer has to be 23.05.2010


I want to subtract 2 days.
Solution that I have:
I have to convert it into day month year then I have to minus from day, month, year.
And again convert in date format.

Shekhar


2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
when you say this "25.05.2010 - 02.05.2010 = Answer has to be 23.05.2010 ", this is not subtracting dates

So what would be answer

25.05.2010 - 4.1.2009?
Posts
11
Registration date
Wednesday September 16, 2009
Status
Member
Last seen
June 16, 2011

hello shekhar

as far as i have understood ur problem, that u want to subtract two dates i.e. 25-05-2010 - 23-05-2010, so the answer may not come in date again, because u already have two dates, As far as i think the answer will come in number of days, ie. 1 or 2 or 3 or so on. And
if you want to subtract days from any date i.e. 25.05.2010 - 25 days, then the answer can come in date format.

So for this a simple formula can be used which is

=(cell address, where date is entered - no. of days want to subtract)

hope this can solve ur problem, if not kindly clarify ur problem

Regards...Vivek
Jsr.