Gestational age

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

Find more posts tagged with

Project Management

Accepted answers

All comments

Antonio Figueroa

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

Paul Newcome

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

Megan Hodgkins

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...

Paul Newcome

Yes.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.