Home arrow Articles arrow Calculate entitled leave in excel
Calculate entitled leave in excel PDF Print E-mail
Written by Administrator   
Saturday, 27 October 2007
This is a function i came up with so we could calculate the number of leave days someone is entitled to.

level1 to 3 years4 to 7 years8 to 10 yearsover 10 years
428303440
324262735
222242628
112141620


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


Add to favourite articles (128) | Place this article on your website | Views: 483

Comment on this article
RSS comments

Only registered users can write comments.
Please login or register.

blabh
Last Updated ( Thursday, 22 November 2007 )