age formulae

Hi All,

I have a field which has age as 4 years 8 months, how will I know the age in
dd/mm/yyyy

any help will be appreciated

thanks

assume cell A1 contains 4 years 8 months

in B1 put this formula

=(value(left(A1,1))*365)+(value(mid(A1,9,2))*30.4)

this does not allow for leap years or the fact that months have either 28, 30 or 31 days.

If you know that 4 years 8 months zero days is correct on todays date, you can calculate date of birth and then subtract that from todays date which gives the exact number of days.

tried though getting 29-Aug-2004, which is not correct

please help

thanks

"robert111" wrote:

>
> assume cell A1 contains 4 years 8 months
>
> in B1 put this formula
>
> =(value(left(A1,1))*365)+(value(mid(A1,9,2))*30.4)
>
> this does not allow for leap years or the fact that months have either
> 28, 30 or 31 days.
>
> If you know that 4 years 8 months zero days is correct on todays date,
> you can calculate date of birth and then subtract that from todays date
> which gives the exact number of days.
>
>
> --
> robert111
> ------------------------------------------------------------------------
> robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
> View this thread: http://www.excelforum.com/showthread...hreadid=529916
>
>

Hi Gerald,

Based on Today(), I get 8.8.2001 ...
Playing around with datedif() function :
=DATEDIF(D10,B10,"Y") & " Years, " & DATEDIF(D10,B10,"YM") & " Months, " & DATEDIF(D10,B10,"MD") & " Days"


HTH
Cheers
Carim

thanks Carim, your formulae will give the age in years and months

I need in dd/mm/yyyy format

e.g. if the age of a person is 10 years 4 months what would be the dob

thanks

"Carim" wrote:

>
> Hi Gerald,
>
> Based on Today(), I get 8.8.2001 ...
> Playing around with datedif() function :
> =DATEDIF(D10,B10,"Y") & " Years, " & DATEDIF(D10,B10,"YM") & " Months,
> " & DATEDIF(D10,B10,"MD") & " Days"
>
>
> HTH
> Cheers
> Carim
>
>
> --
> Carim
> ------------------------------------------------------------------------
> Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
> View this thread: http://www.excelforum.com/showthread...hreadid=529916
>
>

The formula uses dd/mm/yyyy

With the latest input of 10 years 4 months it produces : 08/12/1995 ...

HTH
Carim