Hello!
Maybe someone could help me?
I have a Table with product an order Date und production time
|
Product
|
Production time days
|
Order Date
|
|
A
|
5
|
01.06.2023
|
|
B
|
6
|
06.06.2023
|
|
C
|
3
|
09.06.2023
|
|
D
|
4
|
14.06.2023
|
And another table with workdays
|
Workday
|
|
01.06.2023
|
|
02.06.2023
|
|
05.06.2023
|
|
06.06.2023
|
|
08.06.2023
|
|
09.06.2023
|
|
12.06.2023
|
|
13.06.2023
|
|
14.06.2023
|
|
19.06.2023
|
|
20.06.2023
|
|
21.06.2023
|
|
22.06.2023
|
|
No I need the delivery date. So I have to check die production time and the workday. Result should be
|
Product
|
Production time days
|
Order Date
|
Delivery date
|
|
A
|
5
|
01.06.2023
|
09.06.2023
|
|
B
|
6
|
06.06.2023
|
19.06.2023
|
|
C
|
3
|
09.06.2023
|
14.06.2023
|
|
D
|
4
|
14.06.2023
|
22.06.2023
|
How could I get this?
Thx. Michael
