excel =countofs formula help

[Ghoover]

so I am trying to figure out a formula for the following information.
I want cell J:J to display "Yes" if the conditions in Cell H:H "Scheduled" and cell I:I is the date in the cell +7.

example
H I j
Scheduled 04/20/2020 yes
Scheduled 05/02/2020

I hope this makes sense to who ever reads this

[okela]

Hi,
Could you provide us with a workbook so we can help you?

Thanks

[Ghoover]

I think I need to put more thought into this.
I think its going to end up being a formula and conditioning mixed.
If I could delete this until I have time to think deeper about this I would.

Thank for the offer of assistance.