Calculating Gestation age today from a past date.

[asimrehman]

Hi, I was wondering if somebody can help me.
If we have gestation age in weeks and days from a past USG scan, how can we calculate today's gestation age eg
A1 is date of last US scan eg July 1, 2022.
B1 Gestational age on that that was 16 weeks 4 days.
C1 expected gestational age today in weeks and days.

Thanx in advance.

 

[FormR]

Hi, perhaps you can adapt something like this to your actual layout..

If not, try to describe what layout is and give a few examples along with the expected results for those examples.

Book1
	A	B	C
1	Scan date	Age
2	01-Jul-2022	Weeks	16
3		Days	4
4
5	Today	Expected Age
6	04/08/2022	Weeks	21
7		Days	3
Sheet1

Cell Formulas
Range	Formula
A6	A6	=TODAY()
C6	C6	=INT(((C2*7)+C3+(A6-A2))/7)
C7	C7	=MOD((C2*7)+C3+(A6-A2),7)

 

[Phuoc]

Try this

Book1
	A	B	C
1	1-Jul-22	16 weeks 4 days	21 weeks 3 days
2	10-Jul-22	16 weeks 4 days	20 weeks 1 days
Sheet2

Cell Formulas
Range	Formula
C1:C2	C1	=SUBSTITUTE(TEXT(DOLLARFR((TODAY()-A1+LEFT(B1,FIND(" ",B1)-1)*7+MID(B1,FIND("day",B1)-2,1))/7,7),"0.0"),"."," weeks ")&" days"

 

[asimrehman]

Try this

Book1
	A	B	C
1	1-Jul-22	16 weeks 4 days	21 weeks 3 days
2	10-Jul-22	16 weeks 4 days	20 weeks 1 days
Sheet2

Cell Formulas
Range	Formula
C1:C2	C1	=SUBSTITUTE(TEXT(DOLLARFR((TODAY()-A1+LEFT(B1,FIND(" ",B1)-1)*7+MID(B1,FIND("day",B1)-2,1))/7,7),"0.0"),"."," weeks ")&" days"

Thanx it is working but if you can help me with formula to make the format given below. where in column B 16+4 means 16 weeks 4 days.

 

[Phuoc]

Book1
	A	B	C
1	1-Jul-2022	16+4	21 weeks 4 days
2	10-Jul-2022	16+4	20 weeks 2 days
Sheet1

Cell Formulas
Range	Formula
C1:C2	C1	=SUBSTITUTE(TEXT(DOLLARFR((TODAY()-A1+LEFT(B1,FIND("+",B1)-1)*7+REPLACE(B1,1,FIND("+",B1),""))/7,7),"0.0"),"."," weeks ")&" days"