Add 1 day to a date within a range as long as 2 conditions are met [without macros]

[juanam]

I have a range of dates that correspond to non-business days, what I need to do is add 1 day to a date "x" (found in C15) until I find a day that is a business day (that is, the date is not found within the range, BUT it is not Saturday or Sunday either) and put your result in cell C16.

The date format used corresponds to Uruguay: Day/Month/Year

C15 = 03/07/2023
C16 = *here would be the formula that does the calculation*

Non-working days are in the range F20:F87

01/01/2023
02/01/2023
03/01/2023
04/01/2023
05/01/2023
06/01/2023
07/01/2023
08/01/2023
09/01/2023
10/01/2023
11/01/2023
12/01/2023
13/01/2023
14/01/2023
15/01/2023
16/01/2023
17/01/2023
18/01/2023
19/01/2023
20/01/2023
21/01/2023
22/01/2023
23/01/2023
24/01/2023
25/01/2023
26/01/2023
27/01/2023
28/01/2023
29/01/2023
30/01/2023
31/01/2023
20/02/2023
21/02/2023
02/04/2023
03/04/2023
04/04/2023
05/04/2023
06/04/2023
07/04/2023
08/04/2023
17/04/2023
01/05/2023
22/05/2023
19/06/2023
01/07/2023
02/07/2023
03/07/2023
04/07/2023
05/07/2023
06/07/2023
07/07/2023
08/07/2023
09/07/2023
10/07/2023
11/07/2023
12/07/2023
13/07/2023
14/07/2023
15/07/2023
18/07/2023
16/10/2023
25/12/2023
26/12/2023
27/12/2023
28/12/2023
29/12/2023
30/12/2023
31/12/2023

In the example, the first business date would be 19/07/2023, which I cannot find a way to choose the next consecutive day that is a business day (that is, it is not within that range, BUT it is not a Saturday or Sunday.

If possible, I don't want to use macros.

 

[Fluff]

How about

=WORKDAY(C15,1,F20:F87)

 

[juanam]

How about

=WORKDAY(C15,1,F20:F87)

You make things so simple that I'm ashamed for not having found the solution myself.
Thank you so much!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[juanam]

Hello again @Fluff, sorry for doing this, it may not be appropriate, but I have implemented your solution that is still correct in the final work and it has not worked as it should.
Obviously it's me who doesn't know how to do it.
When you have time, if you can, take a look at this thread.
Thank you!