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.