Well, kinda...

DATEDIF() uses the length of the first month to determine month lengths,
so that leads to some bizarre results:

Assume A1 = 1/31/2007

then some results will look like:

2/27/2009 2 years, 0 months, 27 days
2/28/2009 2 years, 0 months, 28 days
3/1/2009 2 years, 1 months, -2 days
3/2/2009 2 years, 1 months, -1 days
3/3/2009 2 years, 1 months, 0 days
3/4/2009 2 years, 1 months, 1 days
3/5/2009 2 years, 1 months, 2 days

likewise

4/29/2009 2 years, 2 months, 29 days
4/30/2009 2 years, 2 months, 30 days
5/1/2009 2 years, 3 months, 0 days
5/2/2009 2 years, 3 months, 1 days
5/3/2009 2 years, 3 months, 2 days



In article ,
sherry wrote:

Hi All,

If I enter, for example, a birth date in column A1 and the below formula in
another column, I understand the result will be someone's age in years,
months, and days. My question is: Tomorrow, when I open my file, will my
result show one more day added to the "days" number? Thanks for your time.

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"