How to calculate in weeks and days?

[DORI]

I need to calculate the age of babies (under one year old) in weeks and days.
Is there a way that when I enter the birthday of the baby in a cell, another
cell returns the age of the baby in weeks and days in a format like: " 20w5d"
in which "w" is the number of weeks and "d" is the number of days?
I tried DAYS360()/7 function but it is not accurate as it consider one
year=360 days rather than 365, and it returns the number of weeks with
decimal point.
Thanks for your help.
Dori

[Harald Staff]

Hi Dori


With birth date in A1 try
=INT((TODAY()-A1)/7)&"w"&MOD((TODAY()-A1),7)&"d"

HTH. Best wishes Harald

"DORI" <DORI@discussions.microsoft.com> skrev i melding
news:9D5CA8AE-44FC-4E30-8397-6D4435DC606A@microsoft.com...
> I need to calculate the age of babies (under one year old) in weeks and
days.
> Is there a way that when I enter the birthday of the baby in a cell,
another
> cell returns the age of the baby in weeks and days in a format like: "
20w5d"
> in which "w" is the number of weeks and "d" is the number of days?
> I tried DAYS360()/7 function but it is not accurate as it consider one
> year=360 days rather than 365, and it returns the number of weeks with
> decimal point.
> Thanks for your help.
> Dori

[Biff]

Hi!

A1 = birthdate
B1 = =TODAY()

=INT((B1-A1)/7)&"w "&MOD(B1-A1,7)&"d"

Biff

"DORI" <DORI@discussions.microsoft.com> wrote in message
news:9D5CA8AE-44FC-4E30-8397-6D4435DC606A@microsoft.com...
>I need to calculate the age of babies (under one year old) in weeks and
>days.
> Is there a way that when I enter the birthday of the baby in a cell,
> another
> cell returns the age of the baby in weeks and days in a format like: "
> 20w5d"
> in which "w" is the number of weeks and "d" is the number of days?
> I tried DAYS360()/7 function but it is not accurate as it consider one
> year=360 days rather than 365, and it returns the number of weeks with
> decimal point.
> Thanks for your help.
> Dori

[DORI]

Thank you Harald and Biff for the formula. It worked great
Dori

"Harald Staff" wrote:

> Hi Dori
>
>
> With birth date in A1 try
> =INT((TODAY()-A1)/7)&"w"&MOD((TODAY()-A1),7)&"d"
>
> HTH. Best wishes Harald
>
> "DORI" <DORI@discussions.microsoft.com> skrev i melding
> news:9D5CA8AE-44FC-4E30-8397-6D4435DC606A@microsoft.com...
> > I need to calculate the age of babies (under one year old) in weeks and
> days.
> > Is there a way that when I enter the birthday of the baby in a cell,
> another
> > cell returns the age of the baby in weeks and days in a format like: "
> 20w5d"
> > in which "w" is the number of weeks and "d" is the number of days?
> > I tried DAYS360()/7 function but it is not accurate as it consider one
> > year=360 days rather than 365, and it returns the number of weeks with
> > decimal point.
> > Thanks for your help.
> > Dori
>
>
>