Calculating Gestational Age

[sejohnson]

Hello All,

I am creating an outpatient log using Excel for a Labor & Delivery Unit. Is there a way to calculate a gestational age by entering the due date?

Ideally a staff member would enter the EDC (est. date of confinement), say 3/31/2012 in A2 and the EGA (est. gestational age) would generate in B2 as "38+3," "38 3/7" or "38 weeks 3 days".

Thanks in advance for any input!

 

[Phuoc]

1, Remove the $ sign in the address D2

2. Add the $ sign in the address A1

=INT((280-D2+$A$1)/7)&"w"&MOD(280-D2+$A$1,7)&"d"

 

[Ayhtin]

1, Remove the $ sign in the address D2

2. Add the $ sign in the address A1

=INT((280-D2+$A$1)/7)&"w"&MOD(280-D2+$A$1,7)&"d"

thank you!!