Leave Entitlement Calculation

Remark: Round to 0.5 days

Annual Leave Entitlement

Join Date: 01/01/2004

Entitle Year	1st Bound	Result
2004	01/01/2004 - 31/12/2004 (Year 1)	8
2005	01/01/2005 - 31/12/2005 (Year 2)	8
2006	01/01/2006 - 31/12/2006 (Year 3)	12
2007	01/01/2007 - 31/12/2007 (Year 4)	12
2008	01/01/2008 - 31/12/2008 (Year 5)	16
2009	01/01/2009 - 31/12/2009 (Year 6)	16


Join Date: 20/01/2005

Entitle Year	1st Bound	2nd Bound	Result
2005		20/01/2005 - 31/12/2005 (Year 1)	346/365 * 8 = 7.5836 = 8
2006	01/01/2006 - 19/01/2006 (Year 1)	20/01/2006 - 31/12/2006 (Year 2)	((19/365) * 8) + ((346/365) * 8) = 0.4164 + 7.5836 = 8
2007	01/01/2007 - 19/01/2007 (Year 2)	20/01/2007 - 31/12/2007 (Year 3)	((19/365) * 8) + ((346/365) * 12) = 0.4164 + 11.3753 = 11.7917 = 12
2008	01/01/2008 - 19/01/2008 (Year 3)	20/01/2008 - 31/12/2008 (Year 4)	((19/366) * 12) + ((347/366) * 12) = 0.6230 + 11.3770 = 12
2009	01/01/2009 - 19/01/2009 (Year 4)	20/01/2009 - 31/12/2009 (Year 5)	((19/365) * 12) + ((347/365) * 16) = 0.6247 + 15.2110 = 15.8357 = 16


Join Date: 29/02/2000

Entitle Year	1st Bound	2nd Bound	Result
2000		29/02/2000 - 31/12/2000 (Year 1)	(307/366) * 8 = 6.7104 = 7
2001	01/01/2001 - 27/02/2001 (Year 1)	28/02/2001 - 31/12/2001 (Year 2)	((58/365) * 8) + ((307/365) * 8) = 1.2712 + 6.7288 = 8
2002	01/01/2002 - 27/02/2002 (Year 2)	28/02/2002 - 31/12/2002 (Year 3)	((58/365) * 8) + ((307/365) * 12) = 1.2712 + 10.0932 = 11.3644 = 11.5
2003	01/01/2003 - 27/02/2003 (Year 3)	28/02/2003 - 31/12/2003 (Year 4)	((58/365) * 12) + ((307/365) * 12) = 1.9068 + 10.0932 = 12
2004	01/01/2004 - 28/02/2004 (Year 4)	29/02/2004 - 31/12/2004 (Year 5)	((59/366) * 12) + ((307/366) * 16) = 1.9344 + 13.4208 = 15.3552 = 15.5
2005	01/01/2005 - 27/02/2005 (Year 5)	28/02/2005 - 31/12/2005 (Year 6)	((58/365) * 16) + ((307/365) * 16) = 2.5425 + 13.4575 = 16
2006	01/01/2006 - 27/02/2006 (Year 6)	28/02/2006 - 31/12/2006 (Year 7)	((58/365) * 16) + ((307/365) * 16) = 2.5425 + 13.4575 = 16
2007	01/01/2007 - 27/02/2007 (Year 7)	28/02/2007 - 31/12/2006 (Year 8)	((58/365) * 16) + ((307/365) * 16) = 2.5425 + 13.4575 = 16
2008	01/01/2008 - 28/02/2008 (Year 8)	29/02/2008 - 31/12/2008 (Year 9)	((59/366) * 16) + ((307/366) * 16) = 2.5792 + 13.4208 = 16
2009	01/01/2009 - 27/02/2009 (Year 9)	28/02/2009 - 31/12/2009 (Year 10)	((58/365) * 16) + ((307/365) * 16) = 2.5425 + 13.4575 = 16


Join Date: 31/12/2005

Entitle Year	1st Bound	2nd Bound	Result
2005		31/12/2005 - 31/12/2005 (Year 1)	(1/365 * 8) = 0.0219 = 0.5
2006	01/01/2006 - 30/12/2006 (Year 1)	31/12/2006 - 31/12/2006 (Year 2)	((364/365) * 8) + ((1/365) * 8) = 7.9781 + 0.0219 = 8
2007	01/01/2007 - 30/12/2007 (Year 2)	31/12/2007 - 31/12/2007 (Year 3)	((364/365) * 8) + ((1/365) * 12) = 7.9781 = 0.0329 = 8.011 = 8.5
2008	01/01/2008 - 30/12/2008 (Year 3)	31/12/2008 - 31/12/2008 (Year 4)	((365/366) * 12) + ((1/366) * 12) = 11.9672 + 0.0328 = 12
2009	01/01/2009 - 30/12/2009 (Year 4)	31/12/2009 - 31/12/2009 (Year 5)	((364/365) * 12) + ((1/365) * 16) = 11.9671 + 0.0438 = 12.0109 = 12.5




Sick Leave Entitlement

Join Date: 01/01/2004

Entitle Year	1st Bound	Result
2004	01/01/2004 - 31/12/2004 (Year 1)	14
2005	01/01/2005 - 31/12/2005 (Year 2)	14
2006	01/01/2006 - 31/12/2006 (Year 3)	18
2007	01/01/2007 - 31/12/2007 (Year 4)	18
2008	01/01/2008 - 31/12/2008 (Year 5)	22
2009	01/01/2009 - 31/12/2009 (Year 6)	22

Join Date: 20/01/2005

Entitle Year	1st Bound	2nd Bound	Result
2005		20/01/2005 - 31/12/2005 (Year 1)	346/365 * 14 = 13.2712 = 13.5
2006	01/01/2006 - 19/01/2006 (Year 1)	20/01/2006 - 31/12/2006 (Year 2)	((19/365) * 14) + ((346/365) * 14) = 0.7288 + 13.2712 = 14
2007	01/01/2007 - 19/01/2007 (Year 2)	20/01/2007 - 31/12/2007 (Year 3)	((19/365) * 14) + ((346/365) * 18) = 0.7288 + 17.0630 = 17.7918 = 18
2008	01/01/2008 - 19/01/2008 (Year 3)	20/01/2008 - 31/12/2008 (Year 4)	((19/366) * 18) + ((347/366) * 18) = 0.9344 + 17.0656 = 18
2009	01/01/2009 - 19/01/2009 (Year 4)	20/01/2009 - 31/12/2009 (Year 5)	((19/365) * 18) + ((346/365) * 22) = 0.9370 + 20.8548 = 21.7918 = 22



Join Date: 29/02/2000

Entitle Year	1st Bound	2nd Bound	Result
2000		29/02/2000 - 31/12/2000 (Year 1)	(307/366) * 14 = 11.7432 = 12
2001	01/01/2001 - 27/02/2001 (Year 1)	28/02/2001 - 31/12/2001 (Year 2)	((58/365) * 14) + ((307/365) * 14) = 2.2247 + 11.7753 = 14
2002	01/01/2002 - 27/02/2002 (Year 2)	28/02/2002 - 31/12/2002 (Year 3)	((58/365) * 14) + ((307/365) * 18) = 2.2247 + 15.1397 = 17.3644 = 17.5
2003	01/01/2003 - 27/02/2003 (Year 3)	28/02/2003 - 31/12/2003 (Year 4)	((58/365) * 18) + ((307/365) * 18) = 2.8603 + 15.1397 = 18
2004	01/01/2004 - 28/02/2004 (Year 4)	29/02/2004 - 31/12/2004 (Year 5)	((59/366) * 18) + ((307/366) * 22) = 2.9016 + 18.4536 = 21.3552 = 21.5
2005	01/01/2005 - 27/02/2005 (Year 5)	28/02/2005 - 31/12/2005 (Year 6)	((58/365) * 22) + ((307/365) * 22) = 3.4959 + 18.5041 = 22
2006	01/01/2006 - 27/02/2006 (Year 6)	28/02/2006 - 31/12/2006 (Year 7)	((58/365) * 22) + ((307/365) * 22) = 3.4959 + 18.5041 = 22
2007	01/01/2007 - 27/02/2007 (Year 7)	28/02/2007 - 31/12/2007 (Year 8)	((58/365) * 22) + ((307/365) * 22) = 3.4959 + 18.5041 = 22
2008	01/01/2008 - 28/02/2008 (Year 8)	29/02/2008 - 31/12/2008 (Year 9)	((59/366) * 22) + ((307/366) * 22) = 3.5464 + 18.4536 = 22
2009	01/01/2009 - 27/02/2009 (Year 9)	28/02/2009 - 31/12/2009 (Year 10)	((58/365) * 22) + ((307/365) * 22) = 3.4959 + 18.5041 = 22



Join Date: 31/12/2005

Entitle Year	1st Bound	2nd Bound	Results
2005		31/12/2005 - 31/12/2005 (Year 1)	(1/365) * 14 = 0.0384 = 0.5
2006	01/01/2006 - 30/12/2006 (Year 1)	31/12/2006 - 31/12/2006 (Year 2)	((364/365) * 14) + ((1/365) * 14) = 13.9616 + 0.0384 = 14
2007	01/01/2007 - 30/12/2007 (Year 2)	31/12/2007 - 31/12/2007 (Year 3)	((364/365) * 14) + ((1/365) * 18) = 13.9616 + 0.0493 = 14.0109 = 14.5
2008	01/01/2008 - 30/12/2008 (Year 3)	31/12/2008 - 31/12/2008 (Year 4)	((365/366) * 18) + ((1/366) * 18) = 17.9508 + 0.0492 = 18
2009	01/01/2009 - 30/12/2009 (Year 4)	31/12/2009 - 31/12/2009 (Year 5)	((364/365) * 18) + ((1/365) * 22) = 17.9507 + 0.0603 = 18.011 = 18.5