Formula to capture a day in a week

[ToyMiller]

Need to only show for Friday no matter when the sheet is opened.

I have folks that are updating file every Friday. Instead of creating 4 sheets I just want it to show the Friday date for the week. Like 2/15/19, 2/22/19, 3/1/19 and so on. This is feeding into another sheet that has the weeks split up in one sheet.

 

[Scott Huish]

=WORKDAY.INTL(TODAY()-1,1,"1111011")

Format as Date.

 

[ToyMiller]

=WORKDAY.INTL(TODAY()-1,1,"1111011")

Format as Date.

Perfect!