How to subtract two dates
Closed
Shekhar
-
May 18, 2010 at 03:57 AM
love2garv Posts 11 Registration date Wednesday September 16, 2009 Status Member Last seen June 16, 2011 - May 18, 2010 at 06:31 AM
love2garv Posts 11 Registration date Wednesday September 16, 2009 Status Member Last seen June 16, 2011 - May 18, 2010 at 06:31 AM
Related:
- How to subtract two dates
- How to activate facebook dating - Guide
- How to highlight overdue dates in excel ✓ - Excel Forum
- Defcon dates - Guide
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
- Using nested if to blank out adjacent cells - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 18, 2010 at 04:11 AM
May 18, 2010 at 04:11 AM
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?
So what would be answer
25.05.2010 - 4.1.2009?
love2garv
Posts
11
Registration date
Wednesday September 16, 2009
Status
Member
Last seen
June 16, 2011
May 18, 2010 at 06:31 AM
May 18, 2010 at 06:31 AM
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.
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.
