Previous Topic Next Topic

Calculate difference in date

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

Réponse 1 / 1
abbygale45 Posts 6 Registration date Monday 27 October 2014 Status Member Last seen 29 October 2014
29 Oct 2014 à 06:28
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 29 October 2014 Status Member Last seen 29 October 2014
29 Oct 2014 à 06:55
Can you explain in detail

Similar discussions

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

6 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
how do i calculate VAT inclusive
moonga -
Mazzaropi -

1 response
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response