hello!
I am new to this forum, and only know basic excel functions. I'm an excel for dummies candidate for sure.

i would like to set up a vacation accrual spreadsheet, and have modeled a formula from this forum to get me started. The previous person here used paper and a pencil! Ouch! I'm new at this job, and want to simplify it but need a little help.
I thought the formula was similar to my needs based on a simple and "usual" vacation accrual, but i delved into the "paper" and it is different. The modeled formula is:
40 hours after one-year of service,
80 hours after 2-15 years of service,
120 hours after the 15th year.
B2 column is when the employee started with the company
=if(today()-b2<365,0,if(and(today()-b2>365,today()-b2<730),40,if(and(today()-b2>730,today()-b2<5475),80,120)))
the formula is what i need but with a few additions and adjustments such as:
Full time employees:
40 hours after one-year of service
80 hours after two-years of service
88 hours after three years of service
96 hours after five years of service
104 hours after seven years of service
120 hours after ten years of service
144 hours after fifteen years of service
160 hours after 20 years of service
200 hours after 25 years of service
i'm sorry if this may not be posted the correct way.

thank you to all for any help!!!
Bookmarks