Previous Topic Next Topic

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 response

Answer 1 / 1
abbygale45 Posts 6 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.
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses