For your future information, it is not a good idea to tag questions on to an existing thread, especially when it is so old.
The run the chance of your question not being picked.
It is better to start a fresh question.
To answer your query, however, if you just want the difference as the number of days, then it would simply be
but if you wanted the difference as Yaers and Months, then it would be
=IF(B1,DATEDIF(A1,B1,"y")&" Years "&DATEDIF(A1,B1,"Ym")&" months",DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"Ym")&" months")
Microsoft Excel MVP