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

[isabel1217]

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

 

[venkat1926]

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

 

[isabel1217]

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

 

[isabel1217]

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

Isabel