# Calculating and knowing the dates w/in a 40 week period

#### isabel1217

##### Board Regular
Hello I just want to use excel as the easy way to compute
1st Trimester, 2nd Trimester, & 3rd Trimester in a forty week period without having the trouble of looking at the calendar..

Here is the scenario...

One staff is pregnant and her due date is 11/07/2006
and that would be a forty (40) week period. Let's say that July 11, 2006 is the 40th week. I would like to know what would be date on her 12 week period, on her 28 week and the date on her 34 weeks.

Thanks

Isabel1217

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
A B C
week
No. date formula
40 11-Jul-05
28 18-Apr-05 =\$B\$2-(\$A\$2-A3)*7
34 30-May-05 =\$B\$2-(\$A\$2-A4)*7
12 27-Dec-04 =\$B\$2-(\$A\$2-A5)*7
0 04-Oct-04 =\$B\$2-(\$A\$2-A6)*7

plese check whether it is ok

Hello

I am just confused...

How did you get 18-apr-05 as 28 weeks?

\$B\$2 is what?

\$A\$2 is what? and A3 is ???

Thanks

Thanks....I already figure it out how did you end up on those dates...thank you very much...

Isabel

Replies
4
Views
753
Replies
12
Views
317
Replies
3
Views
1K
Replies
1
Views
335
Replies
7
Views
484

1,196,497
Messages
6,015,553
Members
441,900
Latest member
Inaschemitex2023

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back