Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Example:

                     Row A     Row B

Col A: - AMS Alert   1-sep12   1-sep12

Col B: - AMS Alert   4-sep12   4-sep12

Now I want to calculate turn around time for task AMS Alert where I need Excel to take higher date (minus) lower Date, Meaning i want excel to calculate 4th Sep 12 (Minus) 1st Sep 12 = 3 Days.

I have around 5,000 such records and doing this manually is impossible. Is there any formula to do so?

Please help me!

share|improve this question
    
Are your Col/Row labels the wrong way round...??? –  Shevek Oct 8 '12 at 11:36

1 Answer 1

Are the dates strings or are they (formatted) date values? If they're dates, you can simply calculate the difference between MAX() and MIN() of the two values (=MAX(A1:B1)-MIN(A1:B1)), otherwise you should turn convert them into date values first.

share|improve this answer
    
The values are date values,, but the porblem is sometimes i have 10-12 similar rows but the dates in column changes ,,, how the fomula will consider which is the higher date and which is the lower date????? –  Aditya Vaidya Oct 8 '12 at 11:39
1  
See updated answer. If that doesn't help, please update your question with a more representative sample of your data. –  Ansgar Wiechers Oct 8 '12 at 11:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.