mtagliaferri
Board Regular
- Joined
- Oct 27, 2004
- Messages
- 156
I am trying to calculate leave entitlement based on the date of joining and current date, at antry date the person has 20 days of leave if the person has completed their 2nd year anniversary by 01 April then they would get 4 extra days.
E.G.
Thanks
E.G.
- if joining date is 15/03/18 annual leave = 24 (completed 2 years by 01 April of current year 2020)
- if joining date is 15/06/18 annual leave = 20 (has not completed 2 full yeas by 01 April of current year 2020)
Thanks