Sunday, March 29, 2015

yogi_Compute Gestational Age In Weeks_And_Fractions_Of_Weeks Based On Due Delivery Dates

                                           Google Spreadsheet   Post  #1934
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Mar 29, 2015
question by Eric Hawes:!category-topic/docs/spreadsheets/-arkdoM6cVg
Calculation of gestational age
I have a table with due dates in the format of mm/dd/yy in column b and would like to calculate gestational age in column c in the format of weeks and days gestation 
(i.e. 36 3/7 weeks). 

Can someone help me with a formula that I can apply to all of the cells in column C? 
Thank you.