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!