# Vacation accrual formula

#### lemfil

##### New Member
I have been tasked with developing a spreadsheet to track employee vacation accrual. Employees begin accruing andare able to use vacation days once they have been with the company 90 days from their start date. After the calendar year of your hire date has been completed, your vacation willaccrue monthly on a pro-rata basis beginning January 31 (i.e. 0.83 days per month in Year 2).You will start Our vacation policy is as follows.

 Years of Employment Vacation Days Per Year Year One (1) 10 Hire Date January - March Year One (1) 7 Hire Date April - June Year One (1) 4 Hire Date July - September Year One (1) 0 Hire Date October - December Year Two (2) 10 Year Three (3) 11 Year Four (4) 12 Year Five (5) 13 Year Six (6) 14 Year Seven (7) 15 Year Eight (8) 16 Year Nine (9) 17 Year Ten (10) 18 Year Eleven (11) 19 Year Twelve (12) and Over 20 (Maximum)

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

So far I have the following information set up:
A2 - Name
B2 - Start date
C2-N2 - number of days used broken down by month
O2 - Total number of vacation days used this year
P2 - Balance remaining (where I need to input my formula)

I would really appreciate any help anyone can give me.

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
To calculate Total Number of Try this

=INT(IF(NOW()-A9>90,(NOW()-A9)/30,0))

Balance vacation =INT(
IF(NOW()-A9>90,(NOW()-A9)/30,0)) - number of leaves Taken

Replies
17
Views
355
Replies
2
Views
187
Replies
1
Views
284
Replies
2
Views
163
Replies
3
Views
216

1,196,102
Messages
6,013,464
Members
441,767
Latest member
Craigh4444

### 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