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