Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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>
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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."
    Legare Coleman

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pregnancy Countdown (2000)

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

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

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

Posting Permissions

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