Gestational age

Options

Hi all,

I'm sorry if this has been asked before, I can't seem to find anything on it.

I'm looking to calculate gestational age- the age of a fetus in weeks and days using the due date for reference and a typical pregnancy being 40 weeks. I have it in Excel but I can't seem to get it to translate over.

Any help is so appreciated!

Megan

Tags:

• ✭✭✭✭✭✭
Options

Try this

In Weeks Column use this formula

=SUM([Today's Date]@row - [Gestation Start]@row) / 7

in Gestation Start

=[Due Date]@row - 280

and in todays date

=TODAY()

Make sure Gestation Start, Due date and Today's Date are Date Columns

Weeks will be a text number column

• ✭✭✭✭✭✭
Options

There should be no need to have today's date in a separate column.

To track the current gestational period in days...

=TODAY() - [Gestation Start]@row

Current in weeks...

=(TODAY() - [Gestational Start]@row) / 7

Due Date based on gestation start and 40 weeks...

=[Gestational Start]@row + 280

• Options

Thank you both so so much! Is there a way to do weeks AND days? Ex.) 35 weeks and 6 days?

In Excel I had it set up as =FLOOR(279-(E7-TODAY()),7)/7&" weeks "&MOD(279-(E7-TODAY()),7)&" days"

I don't know if that helps at all...

• ✭✭✭✭✭✭
Options

Yes.

=INT(formula_of_choice) + " weeks " + MOD(formula_of_choice, 7) + " days"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!