Bi-Weekly Vacation Accrual Sheet

[3valnntt88]

Hello,

I am in charge of the tracking of Vacation time and I am having a really difficult time creating a formula. As I am not excel proficient.

I would appreciate any help

Our Payroll works as follows:

PAY FREQUENCY -- 2 Times a month (on the 15th & Last Day of the month)

20 Days per year - Average 1.667 days per month or 0.835 Per pay period.

I would like to set up a formula the amount of vacation days an employee will have as of today depending on their hire date.

Thanks in advance!

 

[ranman256]

you really need to get off Excel. This is a database.
you should learn Access. The right tool for the right job.

 

[rpaulson]

not sure where the pay frequency comes in as you state there are 20 vacations days per year.


assuming hire data is in cell A1. FYI: 42736 is Jan 1, 2017

=(TODAY()-MAX(A1,42736))/365*20

hth,

Ross

 

[3valnntt88]

@rpaulson

Thank you SOOOOOOO Much!!!

This has been super helpful.