Thread: Combine 2 formulas
View Single Post
 
Old 09-20-2024, 02:12 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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))
Reply With Quote