nearest friday to date and if date is a friday return that friday not the following

Hi there,

I have found several similar formula's on here but not quite what I need.

I need a date in column a to have 60 days added and then to find the nearest Friday to that date. If the date 60 days on is a friday I want to return that friday and not the next.

i.e.
Date in column A is 25/01/2010 date 60 days is 26/03/2010 which is a frdiay so formula should return this date. It should return this date for anything between 19/01/2010 and 25/01/2010.
The formula I was using is:

=TEXT(A1+60, "dd-mmm-YYYY")+11-(WEEKDAY(NOW()))

However, this returns the following friday if the date + 60 days is a friday.

Please help

Thanks