Calculate difference in date [Closed]

Report
Posts
2
Registration date
Wednesday October 29, 2014
Status
Member
Last seen
October 29, 2014
-
Posts
2
Registration date
Wednesday October 29, 2014
Status
Member
Last seen
October 29, 2014
-
Hello all

I have date column in following format- 21/09/2014 06:26 AM
I want to calculate difference between above date and today.
I tried doing it but I get #value! error
I have tried many things including changing date format and choose text to column but none of these worked for me

Sample data

Date Todays Date Diff in Date
21/09/2014 06:26 AM 29/10/2014 12:26 PM #VALUE!
28/09/2014 02:20 PM 29/10/2014 12:26 PM #VALUE!
29/09/2014 11:37 AM 29/10/2014 12:26 PM #VALUE!
1/10/2014 9:23 29/10/2014 12:26 PM #VALUE!
1/10/2014 14:40 29/10/2014 12:26 PM #VALUE!
6/10/2014 5:14 29/10/2014 12:26 PM #VALUE!
7/10/2014 6:50 29/10/2014 12:26 PM #VALUE!
8/10/2014 10:30 29/10/2014 12:26 PM #VALUE!


Please Help me guys

1 reply

Posts
7
Registration date
Monday October 27, 2014
Status
Member
Last seen
October 29, 2014

The method I used was to first convert it into number of dates and then find the difference by minus formula.
Posts
2
Registration date
Wednesday October 29, 2014
Status
Member
Last seen
October 29, 2014

Can you explain in detail

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!