Computing the date of the next occurring specific weekday

[vabki]

My spreadsheet opens. Cell A1 determines what today is, formatted as "weekday, day month year" (e.g., "Tuesday, 18 February 2014").

I have another cell in which I typically enter the date for the coming Friday. Instead of updating this field once each week, I'd like to calculate the date for the next coming Friday based off the value in cell A1 (to be concise, if "today" happens to be a Friday, then it would calculate the date of next Friday). (Continuing the example above, the coming Friday would be computed as 2/21/2014. If I open the spreadsheet on 2/21, it would calculate 2/28.)

Does anyone know what formula or step(s) to follow to render this value automatically?

Thank you.

[Tony Valko]

Like this...

=A1+CHOOSE(WEEKDAY(A1),5,4,3,2,1,7,6)

[NickyC]

try this
= A1+8-WEEKDAY(A1,15)

[vabki]

Thank you, either of these solutions works perfectly.

[Tony Valko]

We determine the weekday number of the date:

WEEKDAY(A1)

Then add the matching sequence number to the date.

If the weekday is:

1 = Sun, add 5 days to the date
2 = Mon, add 4 days to the date
3 = Tue, add 3 days to the date
4 = Wed, add 2 days to the date
5 = Thu, add 1 day to the date
6 = Fri, add 7 days to the date
7 = Sat, add 6 days to the date