Excel Formula

[Shazir]

Hi team,

I have been looking for a formula that will calculate prorated leave

my company is allowing 15 leaves per year to each employee.
If i want to offer prorated leaves as per the joining date then how to calculate the prorated leaves.

For example an employee come at 1st of April then after 6 months i have to offer 3 months leave to the employee.

any help would be highly appreciated.

 

[Dave Patton]

T202009a.xlsm
	B	C	D
1	Start	End	Leave
2	1-Apr-20	1-Oct-20	7.520548
5c

Cell Formulas
Range	Formula
C2	C2	=EDATE(B2,6)
D2	D2	=(C2-B2)/365*15

Please clarify
1."For example an employee come at 1st of April then after 6 months i have to offer 3 months leave to the employee."?
2. accrual by months or days?
3. minimum accrual?
4. rounding?

 

[Shazir]

Dave Patton

Thank you so much Sir, i was looking for same solution.

Please clarify..
Sir i was looking for an idea to make it further and you gave me thanks alot.