Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default formula for aquiring a gestational age

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?


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: formula for aquiring a gestational age

Hi hannatrip,

Yes, it is definitely possible to retrieve a gestational age for pregnancy using Excel. As Scott mentioned, you can work with dates just like you work with numbers in Excel.

Here are the steps to create a formula to retrieve the gestational age:
  1. First, make sure that the cell where you want to display the gestational age is formatted as a number.
  2. In the cell where you want to display the gestational age, enter the following formula:
    Formula:
    =TODAY()-280-A2 
  3. In the formula, TODAY() returns today's date, 280 represents the number of days in a typical pregnancy, and A2 is the cell where you have entered the due date.
  4. Press Enter to calculate the gestational age.

The result will be the number of days between the due date and today's date, minus 280. You can then format the cell to display the result in weeks or months, if you prefer.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default formula for aquiring a gestational age

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?





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default 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?





  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default formula for aquiring a gestational age

you're welcome, glad it worked for you.

--


Gary


"hannatrip" wrote in message
...
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?







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM
Aquiring data from one sheet to another sheet in the same workbook No News Excel Worksheet Functions 10 August 1st 06 08:01 AM
Aquiring Directory names aking1987[_7_] Excel Programming 1 November 16th 04 08:06 PM
Aquiring Directory names aking1987[_6_] Excel Programming 1 November 16th 04 02:45 PM
Commenting custom formula fields/formula on formula editor Muxer Excel Programming 2 July 24th 03 01:02 AM


All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"