Combine 2 formulas

[Urvo]

Hello forum,
could someone please help me with my problem.
On weekends and public holidays there should be nothing in column D,
unfortunately I can't manage to link the formulas in columns D and E.
Thanks and have a nice evening


Silvio

Hallo Forum,
könnte mir bitte jemand bei meinem Problem behilflich sein.
Wenn Wochenende und bei Feiertagen soll in Spalte D nichts stehen,
d.h. ich bekomme es leider nicht hin die Formeln in Spalte D und E irgendwie zu verknüpfen.
Danke und einen schönen Abend
Silvio

[p45cal]

In D16, copied down:

=IF(WORKDAY(C16-1,1,Feiertage)=C16,$S$8,"")

[p45cal]

You have a formula in A27 of the Feiertage sheet which doesn't work in my UK locale:

=DATEVALUE(TEXT(IF(A26-31 < 1,A26,A26-31),"0#")&"."&IF(A26 > 31,"04.","03.")&B1)

It could work in any locale by changing it to:

=DATE(B1,IF(A26>31,4,3),IF(A26-31<1,A26,A26-31))

[Urvo]

Thank you very much and have a nice weekend.
Regards Silvio