Calculate difference in date

Closed
gururajtiwari Posts 2 Registration date Wednesday October 29, 2014 Status Member Last seen October 29, 2014 - Oct 29, 2014 at 03:06 AM
gururajtiwari Posts 2 Registration date Wednesday October 29, 2014 Status Member Last seen October 29, 2014 - Oct 29, 2014 at 06:55 AM
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

abbygale45 Posts 7 Registration date Monday October 27, 2014 Status Member Last seen October 29, 2014
Oct 29, 2014 at 06:28 AM
The method I used was to first convert it into number of dates and then find the difference by minus formula.
0
gururajtiwari Posts 2 Registration date Wednesday October 29, 2014 Status Member Last seen October 29, 2014
Oct 29, 2014 at 06:55 AM
Can you explain in detail
0