I prepared a leave tracker. Some of the column of this tracker contactains
various data containing formula in relevant columns like;
Column-A = "Previous month Balance" here I put the number of balance days
form the prevoius month.
Column-B = "Earned this month" here I put the number of monthly accural
days.
Column-C = "Total Earned" here I have the sumup of column A + B.
Column-D = "Used this month" here I have the number of days used by the
employee.
Clumnd-E = "Balanced Days" Here I have the difference of Column C - D.

The leave days are adding up every month with a specific prorate amount to
the employees leave balance. According to our rule when an employee completes
his/her one year assignment then we should have to deduct up to 5 days of
leaves from his accrual amount (if the accural amount is more than 5 days,
lesser amount does not need any deduction). So I need this deduction to be
happend automatically.

Please adivse ...

Thanks, Jawed