Sub mw_Arbeitszeiten_eintragen()
Dim i&, j&, Feiertage$
With Tabelle13 ' Feiertage X erfassen
For i = 1 To .Cells(Rows.Count, 1).End(xlUp).Row
If LCase(.Cells(i, 3)) = "x" Then
Feiertage = Feiertage & .Cells(i, 1) & "###"
End If
Next i
End With
For i = 1 To 12
With Sheets(i)
For j = 9 To 39
If WorksheetFunction.Weekday(CDate(.Cells(j, 3))) < 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Mo-Fr ohne Feiertage
.Cells(j, 5) = Format(.Cells(2, 17), "##:##")
.Cells(j, 6) = Format(.Cells(2, 18), "##:##")
End If
If WorksheetFunction.Weekday(CDate(.Cells(j, 3))) = 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Sa ohne Feiertge
.Cells(j, 5) = Format(.Cells(2, 17), "##:##")
.Cells(j, 6) = Format(.Cells(2, 19), "##:##")
End If
If InStr(1, Feiertage, .Cells(j, 3)) > 0 Then .Cells(j, 4) = "F"
Next j
End With
Next i
End Sub
If WorksheetFunction.Weekday(CDate(.Cells(j, 3))) < 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Mo-Fr ohne Feiertage
WorksheetFunction.Weekday(CDate(.Cells(j, 3)),2)
WorksheetFunction.Weekday(CDate(.Cells(j, 3)))
Sub mw_Arbeitszeiten_eintragen()
Dim i&, j&, Feiertage$
With ActiveSheet ' Feiertage X erfassen
For i = 1 To .Cells(Rows.Count, 1).End(xlUp).Row
If LCase(.Cells(i, 3)) = "x" Then
Feiertage = Feiertage & .Cells(i, 1) & "###"
End If
Next i
End With
For i = 1 To 12
With ActiveSheet 'Sheets(i)
For j = 9 To 39
If WorksheetFunction.Weekday(CDate(.Cells(j, 3)), 2) < 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Mo-Fr ohne Feiertage
.Cells(j, 5) = Format(.Cells(2, 18), "##:##")
.Cells(j, 6) = Format(.Cells(2, 19), "##:##")
End If
If WorksheetFunction.Weekday(CDate(.Cells(j, 3)), 2) = 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Sa ohne Feiertge
.Cells(j, 5) = Format(.Cells(2, 18), "##:##")
.Cells(j, 6) = Format(.Cells(2, 20), "##:##")
End If
If InStr(1, Feiertage, .Cells(j, 3)) > 0 Then .Cells(j, 4) = "F"
Next j
End With
Next i
End Sub
If WorksheetFunction.Weekday(CDate(.Cells(j, 3)), 2) < 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Mo-Fr ohne Feiertage
Sub mw_Arbeitszeiten_eintragen()
Dim i&, j&, Feiertage$
With Tabelle13 ' Feiertage X erfassen
For i = 1 To .Cells(Rows.Count, 1).End(xlUp).Row
If LCase(.Cells(i, 3)) = "x" Then
Feiertage = Feiertage & .Cells(i, 1) & "###"
End If
Next i
End With
For i = 1 To 12
With Sheets(i)
.Range("D9:F39").ClearContents
For j = 9 To 39
If .Cells(j, 2) = "" Then Exit For
If WorksheetFunction.Weekday(.Cells(j, 3), 2) < 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Mo-Fr ohne Feiertage
.Cells(j, 5) = Format(Tabelle13.Cells(3, 7), "##:##")
.Cells(j, 6) = Format(Tabelle13.Cells(3, 8), "##:##")
End If
If WorksheetFunction.Weekday(.Cells(j, 3), 2) = 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Sa ohne Feiertge
.Cells(j, 5) = Format(Tabelle13.Cells(3, 7), "##:##")
.Cells(j, 6) = Format(Tabelle13.Cells(3, 9), "##:##")
End If
If InStr(1, Feiertage, .Cells(j, 3)) > 0 Then .Cells(j, 4) = "F"
Next j
End With
Next i
End Sub
Sub mw_Arbeitszeiten_eintragen()
Dim i&, j&, Feiertage$
With Tabelle13 ' Feiertage X erfassen
For i = 1 To .Cells(Rows.Count, 1).End(xlUp).Row
If LCase(.Cells(i, 3)) = "x" Then
Feiertage = Feiertage & .Cells(i, 1) & "###"
End If
Next i
End With
For i = 1 To 12
With Sheets(i)
For j = 9 To 39
If WorksheetFunction.Weekday(CDate(.Cells(j, 3)), 2) < 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Mo-Fr ohne Feiertage
.Cells(j, 5) = Format(.Cells(2, 17), "##:##")
.Cells(j, 6) = Format(.Cells(2, 18), "##:##")
End If
If WorksheetFunction.Weekday(CDate(.Cells(j, 3)), 2) = 6 And InStr(1, Feiertage, .Cells(j, 3)) = 0 Then ' Sa ohne Feiertge
.Cells(j, 5) = Format(.Cells(2, 17), "##:##")
.Cells(j, 6) = Format(.Cells(2, 19), "##:##")
End If
If InStr(1, Feiertage, .Cells(j, 3)) > 0 Then .Cells(j, 4) = "F"
Next j
End With
Next i
End Sub