# Excel Formula

#### Shazir

##### Banned - Rules violations
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.

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

#### Dave Patton

##### Well-known Member
T202009a.xlsm
BCD
1StartEndLeave
21-Apr-201-Oct-207.520548
5c
Cell Formulas
RangeFormula
C2C2=EDATE(B2,6)
D2D2=(C2-B2)/365*15

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

##### Banned - Rules violations
Dave Patton

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

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

Replies
7
Views
774
Replies
6
Views
303
Replies
13
Views
364
Replies
8
Views
216
Replies
3
Views
169

1,129,835
Messages
5,638,621
Members
417,038
Latest member
VBAstudent1977

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back