How to calculate in weeks and days?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Dori


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

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I'm a Dad now... 31
Calculate Net Work Days for 4 day weeks 4
Calculating average ages 5
User defined function returns imprecise value when used in worksheet 3
[newbie] first day of week 3
Spreading date range across days in weeks (advanced) 7
Calculate Gestational Age based on months and weeks 3
Loan payments calculated on 360 day basis 1

Back
Top