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!

 

[romdos]

like this?

[table="class: Grid"]
<tbody>[tr]
[td][/td]
[td]

a​

[/td]
[td]

b​

[/td]
[td]

c​

[/td]
[td]

d​

[/td]
[/tr]
[tr]
[td]

1​

[/td]
[td]

name​

[/td]
[td]

due​

[/td]
[td]

ga [w.d]​

[/td]
[td][/td]
[/tr]
[tr]
[td]

2​

[/td]
[td]elizabeth[/td]
[td]

07/15/2014​

[/td]
[td]

33.0​

[/td]
[td]c2 and down: =dollarfr((today()-b2+280)/7, 7)[/td]
[/tr]
[tr]
[td]

3​

[/td]
[td]barb[/td]
[td]

09/26/2014​

[/td]
[td]

22.4​

[/td]
[td][/td]
[/tr]
[tr]
[td]

4​

[/td]
[td]cara[/td]
[td]

11/09/2014​

[/td]
[td]

16.2​

[/td]
[td][/td]
[/tr]
[tr]
[td]

5​

[/td]
[td]dana[/td]
[td]

12/11/2014​

[/td]
[td]

11.5​

[/td]
[td][/td]
[/tr]
[tr]
[td]

6​

[/td]
[td]ella[/td]
[td]

10/04/2014​

[/td]
[td]

21.3​

[/td]
[td][/td]
[/tr]
[tr]
[td]

7​

[/td]
[td]fran[/td]
[td]

08/27/2014​

[/td]
[td]

26.6​

[/td]
[td][/td]
[/tr]
[tr]
[td]

8​

[/td]
[td]gail[/td]
[td]

07/23/2014​

[/td]
[td]

31.6​

[/td]
[td][/td]
[/tr]
[tr]
[td]

9​

[/td]
[td]hana[/td]
[td]

10/15/2014​

[/td]
[td]

19.6​

[/td]
[td][/td]
[/tr]
[tr]
[td]

10​

[/td]
[td]iris[/td]
[td]

12/01/2014​

[/td]
[td]

13.1​

[/td]
[td][/td]
[/tr]
</tbody>[/table]

yesssss!!

 

[romdos]

Well it didn't work for me. I was previously using Robert's formula above, and it worked but I couldn't figure out how to make it calculate the formula all the way down the column. shg's post is exactly what I want, but when I tried that formula on my sheet it didn't work at all. Mine was starting in C3 so I changed that, but it still didn't work.

 

[shg]

As you can see, it works for my example. Show how your data is arranged.

 

[drvmward]

Hi everyone,

I am hopeless with excel. I am trying to do a similar spreadsheet but instead of basing the corrected gestational age on EDC/EDD, I want to base it on gestational age at birth. eg. Gestation at birth 36 weeks 2 days, Day 2, CGA 36 weeks 4 days.

Can anyone help?!

 

[drvmward]

Any chance you could send this as an attached file?

 

[wheeler89]

Hello,

Wondered if you could help me with another formula for calculating a date based on a due date.

A) I would like to calculate the date on which a woman becomes 24 weeks pregnant based on her due date (which I have, lets say cell A1).

B) I would also like to work out the number of weeks pregnant a woman was on a specific date (in the past) based on her due date.

Any help greatly appreciated!
Amy

 

[khaliamth]

Hello Mr. Excel,
This did not seem to work for my ladies with the estimated date of conception is in one year and will deliver in the next. I actually prefer to have an equation that calculates the gestational age from the estimated delivery date. This is what I have so far:
[TABLE="width: 211"]
<tbody>[TR]
[TD]EDC[/TD]
[TD]# Weeks[/TD]
[/TR]
[TR]
[TD]8/19/2017[/TD]
[TD]6201 weeks 3 days[/TD]
[/TR]
[TR]
[TD]12/16/2017[/TD]
[TD]6201 weeks 3 days[/TD]
[/TR]
</tbody>[/TABLE]

OR the PREFERRED

[TABLE="width: 211"]
<tbody>[TR]
[TD]EDD[/TD]
[TD]# Weeks[/TD]
[/TR]
[TR]
[TD]5/12/2018[/TD]
[TD] ?[/TD]
[/TR]
[TR]
[TD]9/13/2018[/TD]
[TD] ?[/TD]
[/TR]
</tbody>[/TABLE]

 

[khaliamth]

How do we add this and still have the original gestation date equation?

 

[barry houdini]

If you have expected delivery date in B1 and an appointment date A2 then try this formula

=INT((279-$B$1+A2)/7)&"w"&MOD(279-$B$1+A2,7)&"d"

You can use the formula I suggested earlier, EDD in B1, today's date in A2

 

[Ayhtin]

You can use the formula I suggested earlier, EDD in B1, today's date in A2

Hi Barry, I have been searching for formulas for calculating gestational age from a due date and yours is by the far the best I found so far. I am extremely novice at excel. My calculation works more accurately with 280 instead of 279. however I was wondering if you could help me format the formula to adjust to multiple cells but always have today's date be in A1 as a fixed function. I want the list to automatically adjust based on today's date every time it is accessed and I want to be able to add new patients and just enter a due date in one column and the GA (gestational age) column will automatically calculate for that row. Here I did three examples of what I need but I had to manually adjust the formula under GA for each new row. for example for the third patient in row 4 this was my formula: =INT((280-$D$4+A1)/7)&"w"&MOD(280-$D$4+A1,7)&"d"

So I need each new row under GA to automatically go back to A1 as today's date but use whichever new D row it is next to. I hope that makes sense and seems like something that should be possible. I did use the today formula for A1 so I am assuming that it will change each day. thanks

12/3/2019​	Last Name	First Name	EDD	GA
	doe	sandy	6/5/2020​	13w4d
	smith	jane	7/5/2020​	9w2d
	test	mary	4/15/2020​	20w6d