1. ## Pregnancy Countdown (2000)

Conception date in A1 is 10/24/06 the Due Date in B1 is 7/17/07 what formula in C1 will give me the weeks and Days of the person pregnant?

2. ## Re: Pregnancy Countdown (2000)

I am not sure what you are asking. Do you want the number of weeks and days that the person has been pregnant? If so, this should do it:

<code>
=INT((TODAY()-A1)/7)&" weeks and "&MOD((TODAY()-A1),7)&" days"
</code>

If you are looking for the number of weeks and days left until delivery, then:

<code>
=INT((B1-TODAY())/7)&" weeks and "&MOD((B1-TODAY()),7)&" days"
</code>

3. ## Re: Pregnancy Countdown (2000)

In cell C1 insert this formula : =DATEDIF(A1,B1,"d") which will give you the numbers of day left.
change "d" to "m" will give you the numbers of months left.

Hope this help.

cheers, francis

4. ## Re: Pregnancy Countdown (2000)

With the formula (=INT((TODAY()-A1)/7)&" weeks and "&MOD((TODAY()-A1),7)&" days") it gives me 6 weeks when the Dr and the Attachment said it should be 8 weeks

5. ## Re: Pregnancy Countdown (2000)

Since I am not an obstetrician, you are going to have to define how to calculate "in obstetric terms." If I go to a normal calendar, I count exactly six calendar weeks between 10/24/2006 and 12/5/2006. I don't have a clue how to calculate in "obstetric terms."

6. ## Re: Pregnancy Countdown (2000)

"In obstetric terms" is to add 2 weeks to the "calendar weeks"

<hr>Since the time from onset of menstruation to ovulation (= conception = egg retrieval for high tech pregnancies) is usually 2 weeks<hr>
{from the note in the site on the Due Date Calculator]

Thus the formula "in obstetric terms" would be:
=INT((TODAY()-A1)/7)+2 &" weeks and "&MOD((TODAY()-A1),7)&" days"

Steve

7. ## Re: Pregnancy Countdown (2000)

That works for me! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

8. ## Re: Pregnancy Countdown (2000)

<img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> Plus the fact both Jezzarette 1 & 2 were born at 42 weeks and induced which is the maximum they can be in there <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•