Calculating gestational age for an admission using EDD

[keccles]

Hi can anyone help with a formula to work out someone's gestation on a certain date by using their EDD.
They are 40 weeks on their EDD.

Trying to work out, for example, how many weeks and days someone is on the date in the right hand column.

I have tried so many formulas but still can't get it.
Can anyone help please??

Thank you

 

[shg]

EDD	As of	w/d
13 Jan 2025	6 Sep 2024	18 3/7	C2:=(A2-B2)/7
3 Nov 2024	6 Sep 2024	8 2/7
27 Dec 2024	9 Sep 2024	15 4/7
5 Dec 2024	10 Sep 2024	12 2/7
22 Dec 2024	13 Sep 2024	14 2/7

Format column C as Fraction

 

[keccles]

Hi that doesn't seem to

EDD	As of	w/d
13 Jan 2025	6 Sep 2024	18 3/7	C2:=(A2-B2)/7
3 Nov 2024	6 Sep 2024	8 2/7
27 Dec 2024	9 Sep 2024	15 4/7
5 Dec 2024	10 Sep 2024	12 2/7
22 Dec 2024	13 Sep 2024	14 2/7

Format column C as Fraction

Hi that doesn't seem to be working.

The top one for example is coming up they are 7 weeks when it should be 33 weeks gestation. Is it possible to split to weeks and days. eg. 35+2

 

[keccles]

Hi that doesn't seem to

Hi that doesn't seem to be working.
View attachment 118972
The top one for example is coming up they are 7 weeks when it should be 33 weeks gestation. Is it possible to split to weeks and days. eg. 35+2

I've figured it out: =(280-(I2-K2))/7

 

[NoSparks]

Does this help at all

Book1
	A	B	C	D	E	F
1	EDD	EDD Minus 40 weeks	Date of Concern	Week along using column B	Weeks along not using column B	Weeks to go
2	13-Jan-2025	8-Apr-2024	6-Sep-2024	21 weeks, 4 days	21 weeks, 4 days	18 weeks, 3 days
3	30-Nov-2024	24-Feb-2024	6-Sep-2024	27 weeks, 6 days	27 weeks, 6 days	12 weeks, 1 days
4	30-Nov-2024	24-Feb-2024	9-Sep-2024	28 weeks, 2 days	28 weeks, 2 days	11 weeks, 5 days
5	27-Dec-2024	22-Mar-2024	10-Sep-2024	24 weeks, 4 days	24 weeks, 4 days	15 weeks, 3 days
6	5-Dec-2024	29-Feb-2024	10-Sep-2024	27 weeks, 5 days	27 weeks, 5 days	12 weeks, 2 days
7	22-Dec-2024	17-Mar-2024	13-Sep-2024	25 weeks, 5 days	25 weeks, 5 days	14 weeks, 2 days
8	25-Oct-2024	19-Jan-2024	6-Sep-2024	33 weeks	33 weeks	7 weeks
Sheet1

Cell Formulas
Range	Formula
D2:D8	D2	=INT((C2-B2)/7)&" weeks"&IF(MOD(C2-B2,7)=0,"",", "&MOD(C2-B2,7)&" days")
E2:E8	E2	=INT((C2-(A2-(40*7)))/7)&" weeks"&IF(MOD(C2-(A2-(40*7)),7)=0,"",", "&MOD(C2-(A2-(40*7)),7)&" days")
F2:F8	F2	=INT((A2-C2)/7)&" weeks" & IF(MOD(A2-C2,7)=0,"",", " & MOD(A2-C2,7)&" days")
B2:B8	B2	=A2-(40*7)