# Employee Vacation / Holiday accrual spreadsheet

1. ## Employee Vacation / Holiday accrual spreadsheet

Hi All

I need help with my spreadsheet. I used Excel 2013 template to create employee absence schedule but I want to add if they have enough accrued hrs/days.

Currently, I need help with formula so their holiday balance is accruing every week.
On a weekly basis employee is accruing 3.85 or 4 hrs (depends how long he worked for the company).
Less than 5 years rate is 3.85 hrs and more than 5 years is 4 hrs.

I attached example sheet for accruing vacation.
E column is employee current balance from last week.

Thanks

2. ## Re: Employee Vacation / Holiday accrual spreadsheet

``Please Login or Register  to view this content.``
Works out the accrual

3. ## Re: Employee Vacation / Holiday accrual spreadsheet

Hi

I have tried and I must doing something wrong as doesn't work.
What means @ in your formula?
Also not too sure why you use [Years Worked].
Sorry for dumb questions I'm only beginner.

Thanks

4. ## Re: Employee Vacation / Holiday accrual spreadsheet

Years worked and Holiday Accrual rate are your table headers. The @[sdfasdfasd] etc is using the table column names rather than the cell addresses.

5. ## Re: Employee Vacation / Holiday accrual spreadsheet

I've got your formula working but that's not what I'm looking for.

What I need is to get a formula so every week (on Monday ideally) employee Holiday accrual hours balance is raising automaticly by Holiday Accrual Rate (4hrs or 3.85hrs).
Example: Name 1 has got currently 103.89hrs of holiday available so next week should have 4hrs more 107.89.

6. ## Re: Employee Vacation / Holiday accrual spreadsheet

I just been searching forum and I did find that you helped here other guy and I used your formula but it still needs a bit tweaking.

I adjusted this formula to my needs for name1 =103.89+((DATEDIF(B23,B24,"m")+IF(DAY(TODAY())<17,-1,0))*D2) but it calculates on a monthly basis and I need every seven days.
B23: starting date
B24: =today()
D2: 4 (Holiday Accrual Rate (Hrs))

7. ## Re: Employee Vacation / Holiday accrual spreadsheet

anyone can help on this one?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1