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     www.energyefficientbuild.com.    Mar 29, 2015
question by Eric Hawes:
https://productforums.google.com/forum/#!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.
-------------------------------------------------------------------------------------------------------