How to calculate in weeks and days?
 

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

How to calculate in weeks and days?
 

Hi Dori


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

HTH. Best wishes Harald

"DORI" skrev i melding
...
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

How to calculate in weeks and days?
 

Hi!

A1 = birthdate
B1 = =TODAY()

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

Biff

"DORI" wrote in message
...
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

How to calculate in weeks and days?
 

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" skrev i melding
...
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