ummm .. so how do I go around that?

thanks a million for your reply ..


"JE McGimpsey" wrote:

Just a note on your technique:

DateDif assumes that months, using the "md" switch, are as long as the
starting month, so that if the value of the cell in column A is, say

A1: 31 Jan 2005

then on 1 March 2008, the result will be

3Y 1M -1D

and on 2 March 2008, the result will be

3Y 1M 0D

which may not be what you're expecting...

In article ,
Tendresse wrote:

If I am using the formula below to calculate the age when entering the date
of birth in column A:A

=DATEDIF(A:A,TODAY(),"y") & "Y " & DATEDIF(A:A,TODAY(),"ym") & "M " &
DATEDIF(A:A, TODAY(), "md") & "D"

The age then appears as in: 9Y 3M 15D