Cell Formula Returning Date of 4th Friday, 8th Friday, etc., Following a Given Friday Date ??

[monirg]

Hello;

1) I need a formula in A6 to return the date of the 4th Friday, or 8th Friday, or 12th Friday, etc. (one at a time) following a given Friday date in cell A2.

2) For example, let us say I have in A2 the Friday date: Sep 02, 2011.
And I have in A4 a drop-down list: 1, 2, 3, ..., 52
Now, if I select 3 in A4, the formula in A6 should return the date of the third 4th Friday following the Sep 02, 2011 of A2.

3) In the above example, the formula in A6 should return: Sep 30, 2011 (30/09/2011)
and if I select 4 in A4, it should return in A6: Oct 28, 2011 (28/10/2011)

Can someone please help ?

 

[SteveO59L]

=a2+(a4*7)

 

[monirg]

Steve;

Thank you for your prompt reply and for providing such embarrassingly simple formula! I don't know what I was thinking!

Correction: Item 3 of my OP should read:

3) In the above example, the formula in A6 should return: Nov 25, 2011 (25/11/2011)
and if I select 4 in A4, it should return in A6: Dec 23, 2011 (23/12/2011)

and your formula should accordingly read:

=a2 + a4*28

Thanks again for your help.