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