Prev: In excell 2003, increasing number of items shown in drop down list
Next: how do I convert date format yyyymmdd to mm/dd/yyyy
From: Polly on 11 Feb 2010 05:20
Many thanks, it works.

"Eduardo" wrote:

> Hi,
> I assume you have today() formula in D5 and entered the new date in E5
>
> =DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months
> "&DATEDIF(D5,E5,"md")&" days"
>
> "Polly" wrote:
>
> > Might seem obvious but I can't find an answer in Excel Help. I am trying to
> > calculate age in years, months and days by subtracting cell containing date
> > of birth from cell containing today function. Using 2007.
> > Many thanks.
From: Polly on 11 Feb 2010 05:21
Many thanks - I now know how old I am!

"Glenn" wrote:

> Polly wrote:
> > Might seem obvious but I can't find an answer in Excel Help. I am trying to
> > calculate age in years, months and days by subtracting cell containing date
> > of birth from cell containing today function. Using 2007.
> > Many thanks.
>
>
> http://www.cpearson.com/Excel/datedif.aspx
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: In excell 2003, increasing number of items shown in drop down list
Next: how do I convert date format yyyymmdd to mm/dd/yyyy