formula for aquiring a gestational age

[Scott]

Yes.

You can work with dates the same way you work with numbers. (Just make
sure the cell is formatted as a date.)

ie. If A2 has the Due Date, you can put =A2-280 in B2 to get the other
date.

Scott

I am sooo stuck, I need a formula to retrieve a gestational age for
pregnancy. I need to be able to put in the due date, subtract 280 days from
todays date. is this possible?

[hannatrip]

here is what i have come up with so far:
lmp due date todays date
38878 (6/10/06) 39158 3/17/07 I need to know how many weeks the
patient is on the date i open up the file (which will be every other day)

there is 280 days or 40 weeks in between.

thank you in advance

I am sooo stuck, I need a formula to retrieve a gestational age for
pregnancy. I need to be able to put in the due date, subtract 280 days from
todays date. is this possible?

[Gary Keramidas]

here's one way.

in a2: 6/10/06
in b2: =a2+280
in c2: =TRUNC((TODAY()-A2)/7)& " weeks " & MOD(TODAY()-A2,7) & " days"

the results should show:

b2 = 3/17/2007
c2=30 weeks 6 days
--
Gary

I tried what you showed me and it worked but how do i get the weeks up to
todays date though?

Post by Scott
Yes.
You can work with dates the same way you work with numbers. (Just make
sure the cell is formatted as a date.)
ie. If A2 has the Due Date, you can put =A2-280 in B2 to get the other
date.
Scott

I am sooo stuck, I need a formula to retrieve a gestational age for
pregnancy. I need to be able to put in the due date, subtract 280 days from
todays date. is this possible?

[hannatrip]

Gary,
thank you sooo much, it is perfect!!!

Post by Gary Keramidas
here's one way.
in a2: 6/10/06
in b2: =a2+280
in c2: =TRUNC((TODAY()-A2)/7)& " weeks " & MOD(TODAY()-A2,7) & " days"
b2 = 3/17/2007
c2=30 weeks 6 days
--
Gary

I tried what you showed me and it worked but how do i get the weeks up to
todays date though?

Post by Scott
Yes.
You can work with dates the same way you work with numbers. (Just make
sure the cell is formatted as a date.)
ie. If A2 has the Due Date, you can put =A2-280 in B2 to get the other
date.
Scott

I am sooo stuck, I need a formula to retrieve a gestational age for
pregnancy. I need to be able to put in the due date, subtract 280 days from
todays date. is this possible?

[Gary Keramidas]

you're welcome, glad it worked for you.
--
Gary

Post by hannatrip
Gary,
thank you sooo much, it is perfect!!!

Post by Gary Keramidas
here's one way.
in a2: 6/10/06
in b2: =a2+280
in c2: =TRUNC((TODAY()-A2)/7)& " weeks " & MOD(TODAY()-A2,7) & " days"
b2 = 3/17/2007
c2=30 weeks 6 days
--
Gary

I tried what you showed me and it worked but how do i get the weeks up to
todays date though?

Post by Scott
Yes.
You can work with dates the same way you work with numbers. (Just make
sure the cell is formatted as a date.)
ie. If A2 has the Due Date, you can put =A2-280 in B2 to get the other
date.
Scott

I am sooo stuck, I need a formula to retrieve a gestational age for
pregnancy. I need to be able to put in the due date, subtract 280 days from
todays date. is this possible?