Running gestational age

[JoyceLSrn]

Hello! I‘d appreciate your help!

I‘d like to make a sheet that updates gestational age automatically based on today’s date. If this is not possible to do automatically and I‘d need to manually enter today’s date that is fine too, just let me know. I assume if this is the case one of the columns has to be ”today’s date”.

Here is how I’d like to set up the sheet
A1: Gestational Age
B1: Age
C1: Estimate date of delivery
D1: Name

Example:
A1: gestational age 14 weeks+ 0 days, written 14+0 or 14.0
B1: age 31 (does not modify gestational age)
C1: 8/29/20
D1: name

Thank you!!

 

[Tetra201]

See if the following formula in cell A1 works for you (format cell A1 as Number with 1 decimal place):

=DOLLARFR((TODAY()-C1+280)/7,7)