First of all, you don't need to actually "type in" a base date anywhere. You
just use the date you want to use. In my case, they are birth dates. Type
in your birthdate in A1. Type in the formula in B1 and it will show you how
old you are in years, months and days. That's all I need to show.

Secondly, I will never have the problem you're describing (for this task
anyway) because the examples that are showing errors are future dates. Once
again, I am using birth dates. You need to be born before I can enter your
date so I will not be putting in future dates! :)
--
sherry


"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"
--
sherry