Pro rate annual and sick leaves base on year

[ridwanr]

Hi all,
Am looking for an excel formula in which it calculates the annual leaves year entitlement and sick leave remaining entitlement on a pro rate basis base on the current year taking into consideration the start date.

Note that: the total number of total numbers of local leaves allocated for one year is 176. (22*8)
Total number of sick leaves allocated for one year is 120. (15*8)
Total number of working hours per days is 8 hours per day.

Pls see attached for reference.

Thanking you in advance for your help.
Regards,
Ridwan

 

[vletm]

ridwanr
Should someone else guess, what would Your
on a pro rate basis base on the current year taking into consideration the start date.
mean?
What are expected results?