Combine 2 formulas

Urvo · #1 09-20-2024, 10:02 AM

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 · #2 09-20-2024, 01:58 PM

In D16, copied down:

Code:

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

p45cal · #3 09-20-2024, 02:12 PM

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

Code:

=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:

Code:

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

Urvo · #4 09-21-2024, 12:42 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine 2 formulas	Celo	Excel	2	11-18-2022 06:13 AM
How to combine these formulas into one?	LearnerExcel	Excel	2	12-27-2017 12:41 AM
Possible to combine 3 different workbooks?	markg2	Excel	5	11-14-2016 12:36 AM
Please help me to combine these code together	lbf200n	Word VBA	3	12-09-2012 04:22 PM
Combine two forms into one	lwisniewski	Word VBA	3	12-24-2010 03:45 PM