Find Days Remaining with many criteria's

Where you are getting wrong result and what it your expected result for that

Thank You for your reply Siva

Like whenever the date in EXP Date Column is less than the the date in A2 it should reflect already expired and if more than A2 but less than B2 then show the differences and if the date in Exp date are equal to the dates in the A2 & B2 then it should display expired, if the date in the Exp date column is more than the 2 dates mentioned in the A2 & B2 Then it should display how many days it has to get expired from the Criteria Mentioned in A2 & B2 and if the dates falls between the 2 criteria's then it should take the difference and mention and display how many days are left for it to get expired.

e4=IF(D4<A$2,"All Ready Expired",IF(AND(A$2=D4,B$2=D4),"Expired",MIN(D4-A$2,B$2-A$2)))
try this and copy towards down

I am not sure
=IF(D4<A$2,"All Ready Expired",IF(AND(A$2=D4,B$2=D4),"Expired",MAX(0,D4-A$2)))
Try this
one more thing to ask you
What is the use of Until Date in B2 here

if the above is not works
tell me the step step logic

Thank For your reply

It works iam getting that 165 days . Now about that until date in B2 , That is to show today until that date( in the B2) how may passports are going to get expired. its Just to show , so we can plan ahead and inform the employee's before time to get it renewed. I hope you got the idea. now in spread sheet i dragged it down its not taking the difference i.e Exp date minus the date in B2 cell( which is 28/02/2015) and the Exp date in one of the columns is 26/02/2015 .

What is your expected result in this case

Tell me
1) if D4 > A2 and D4>B2 What your result would be
2) if D4 > A2 and D4<B2 What your result would be
3) if D4 < A3 and D4<B2 What your result would be
4) if D4 < A3 and D4>B2 What your result would be
5) if D4 = A3 and D4=B2 What your result would be

i am asking what is your expected result in the above cases

In your worksheet
1) if D4 > A2 and D4>B2 What your answer in E4 (Already expired or expired or B2-A2 or D4-A2 or D4-B4)
2) if D4 > A2 and D4<B2 What your answer in E4 (Already expired or expired or B2-A2 or D4-A2 or D4-B4)
3) if D4 < A3 and D4<B2 What your answer in E4 (Already expired or expired or B2-A2 or D4-A2 or D4-B4)
4) if D4 < A3 and D4>B2 What your answer in E4 (Already expired or expired or B2-A2 or D4-A2 or D4-B4)
5) if D4 = A3 and D4=B2 What your answer in E4 (Already expired or expired or B2-A2 or D4-A2 or D4-B4)
if you answer the above i will write the formula