Calculating End of Week Date

I would like to amend the following formula so that the end result is always adjusted to be a following Friday date. Will appreciate some help.   If([Category] = "PNP", WeekdayAdd([Equip Reqd By],-...