Sub
arbeitstage()
Dim
wert
Dim
i
wert = ActiveSheet.Range(
"A1"
)
For
i = 1
To
12
If
ActiveSheet.Cells(10, 1 + i) <>
""
Then
ActiveSheet.Cells(10, 1 + i) =
""
Else
ActiveSheet.Cells(10, 1 + i).FormulaLocal =
"=(NETTOARBEITSTAGE("
& Chr(34) & DateSerial(wert, i, 1) & Chr(34) &
";"
& Chr(34) & DateSerial(wert, i + 1, 1) - 1 & Chr(34) &
"))"
ActiveSheet.Cells(11, 1 + i) = ActiveSheet.Cells(10, 1 + i) * 8
End
If
Next
i
End
Sub