How to calculate the date 3rd friday from a specific date

[Wembley53]

Hello,

I wonder if anyone can offer some assistance.
I have a spreadsheet that logs the launch date of specific work items. The launch date can be any day of the week. What I want to do is create a formula that calculates the return date which is the date of the 3rd Friday from that launch date.

Thanks

 

[JamesW]

Hi there,

Try:

=A1+MOD(6-WEEKDAY(A1),7)+14

 

[Wembley53]

Works a treat! Thanks very much.

 

[barry houdini]

You can even do without the MOD function, this will give you the same result as JamesW's suggestion

=A1+21-WEEKDAY(A1+1)

although I note that if A1 is a Friday that gives you the date 14 days later, is that right or should it be 21? If it's the latter then change to this version

=A1+22-WEEKDAY(A1+2)

 

[Wembley53]

Thanks for your help.