Return the date of the 1st Friday after a particular date

I am trying to determine the Friday after a particular date in any given year, but the current formula I have is returning the Friday in the same week of the date it is referencing, rather than the Friday after the specific date;

Example:

Saturday April 12, 2014 (Cell D29)

=D29+(6-(WEEKDAY(D29,1)))

The value it returns is Friday, April 11, 2014

I need it to return the Friday after Saturday April 12, 2014 or any given date.

Please Help!!!!

Yes. Thank you very much

This will always give you the date of the next Friday:

=IF(WEEKDAY(D29)>5,7,0)+D29+(6-(WEEKDAY(D29)))

even if the date in D29 is a Friday. If you don't want that, then change the >5 term to >6.

Hope this helps.

Pete