This is a function i came up with so we could calculate the number of leave days someone is entitled to.
| level | 1 to 3 years | 4 to 7 years | 8 to 10 years | over 10 years |
| 4 | 28 | 30 | 34 | 40 |
| 3 | 24 | 26 | 27 | 35 |
| 2 | 22 | 24 | 26 | 28 |
| 1 | 12 | 14 | 16 | 20 |
Code:
Function GetDays(level As Integer, startdate As Date)
Dim NumYears As Integer, levels As Variant
NumMonths = DateDiff("m", startdate, Date)
NumYears = Fix(NumMonths / 12)
Select Case (level)
Case 4
levels = Array(28, 30, 34, 40)
Case 3
levels = Array(24, 26, 27, 35)
Case 2
levels = Array(22, 24, 26, 28)
Case 1
levels = Array(12, 14, 16, 20)
End Select
Select Case (NumYears)
Case 1 To 3
GetDays = levels(0)
Case 4 To 7
GetDays = levels(1)
Case 8 To 10
GetDays = levels(2)
Case Is > 10
GetDays = levels(3)
Case Else
GetDays = 0
End Select
End Function
Only registered users can write comments.
Please login or register.
blabh