• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pro rate annual and sick leaves base on year

ridwanr

New Member
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
 

Attachments

vletm

Excel Ninja
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?
 
Top