Outputting a particular day of the week

[Bash007]

I'm using =C45+(7-WEEKDAY(C45,15)+1) to display the date of the next Friday in a target cell when the source cell is C45. I need to adapt this so that the target cell, a) only displays dates that are Fridays and b) is always at least 4 days later than the source cell. So e.g. if source cell is 9 October 2023 (Monday) then target cell should display 13 October 2023. But if source cell is 10-16 October then the target cell should display 20 October.

Any advice appreciated, thank you.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=WORKDAY.INTL(C45,1+(WEEKDAY(C45,15)>4),"1111011")

 

[GraH]

Book1
	D	E
2	9/10/2023	13/10/2023
3	15/10/2023	20/10/2023
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=WORKDAY.INTL(D2,1,"1111011",)

EDIT: beaten by Fluff

 

[Bash007]

Hi & welcome to MrExcel.
How about

=WORKDAY.INTL(C45,1+(WEEKDAY(C45,15)>4),"1111011")

Thank you so much. This worked great.

 

[Fluff]

Glad we could help & thanks for the feedback.