Calculate 4th Friday from a date

[javifais]

I need to collect forms from many departments. I want to give each department 3 weeks to a month to return their forms. I would like calculate 4th Friday from the date I asked them to fill the forms.
For example, if I asked them to fill the forms on November 20th, then they should get the forms back to me by December 15. If I asked them on November 24, 2017, then they should get the forms to me by November 22.

 

[mole999]

Date in A1

=A1 + (6 - WEEKDAY(A1)+28)

 

[javifais]

Date in A1

=A1 + (6 - WEEKDAY(A1)+28)

This formula calculates 5 Fridays. If I input 9/19/2017, it gives 10/20/2017. Fourth Friday is on 10/13/2017.

 

[javifais]

Thanks Mole999. I adjusted the formula to add 21 days and it works for 9/19/2017, but not for 10/27/2017.

 

[Rick Rothstein]

Give this formula a try...

=A1-WEEKDAY(A1)+IF(WEEKDAY(A1)>5,34,27)

 

[javifais]

Thanks Rick, your formula worked.
Thanks Mole999 for taking the time to help me.

 

[barry houdini]

This formula will give the same results as Rick's

=A1+29-WEEKDAY(A1+2)

or perhaps more transparent with WORKDAY.INTL

=WORKDAY.INTL(A1,4,"1111011")