Jun 16, 2025
Оfftopic Community
Оfftopic Community
Forums
New posts
Search forums
What's new
Featured content
New posts
New media
New media comments
New resources
New profile posts
Latest activity
Media
New media
New comments
Search media
Resources
Latest reviews
Search resources
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Lifestyle
Travel and Vacation
What's the EXCEL formula for vacation days?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="beardoweirdo" data-source="post: 2511714" data-attributes="member: 858472"><p>"enter a formula using nested IF & AND functions to determine the number of vacation days (based on rules below) each employee is eligible for based on employee's status & length of time employed." </p><p></p><p>15 days for full time employees who have worked 4 or more years</p><p>10 days for full time employees who have worked 2 years but less than 4</p><p>5 days of full time employees who have worked 1 year but less than 2</p><p>0 for everyone else</p><p></p><p>So I know my variables: Status, and Years of Employment, I just dont know how to put it into a single IF Formula....Help!</p></blockquote><p></p>
[QUOTE="beardoweirdo, post: 2511714, member: 858472"] "enter a formula using nested IF & AND functions to determine the number of vacation days (based on rules below) each employee is eligible for based on employee's status & length of time employed." 15 days for full time employees who have worked 4 or more years 10 days for full time employees who have worked 2 years but less than 4 5 days of full time employees who have worked 1 year but less than 2 0 for everyone else So I know my variables: Status, and Years of Employment, I just dont know how to put it into a single IF Formula....Help! [/QUOTE]
Insert quotes…
Name
Verification
Please enable JavaScript to continue.
Loading…
Post reply
Top