formula for aquiring a gestational age
Gary,
thank you sooo much, it is perfect!!!
"Gary Keramidas" wrote:
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
"hannatrip" wrote in message
...
I tried what you showed me and it worked but how do i get the weeks up to
todays date though?
"Scott" wrote:
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
hannatrip wrote:
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?
|