software

Good evening Excel Gurus

In a situation where I want to determine the number of vacation days an
employees would have...

In A1 I have the hire date
In B1 I want to determine the number of days of vacation the person may have
using the following conditions:
- From 0 to 6 months --gt; 0 Days
- From 6 months to less than 1 --gt; 5 days
- From 1 to Less than 5 --gt; 10 days
- From 5 to less than 12 --gt; 5 days
- From 12 to 20 --gt; 20 days

This situation is a challenge because in the cell B1
- I need to determine the number of year/months/days based on today's date
compared to the HIRE DATE in A1
- I need to have several quot;ifquot; condition tested at the same time

Can someone help?

Thanks so much

Create a table like so

............... I..............J............K
1.............20...........20............0
2.............15...........12............0
3.............10.............5............0
4................5............1............0
5...............0.............0............6

then in H1 add and copy down to H5.

In B1, use =VLOOKUP(A1,$H$1:$I$5,2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;MIchel Khennafiquot; gt; wrote in message
...
gt; Good evening Excel Gurus
gt;
gt; In a situation where I want to determine the number of vacation days an
gt; employees would have...
gt;
gt; In A1 I have the hire date
gt; In B1 I want to determine the number of days of vacation the person may
have
gt; using the following conditions:
gt; - From 0 to 6 months --gt; 0 Days
gt; - From 6 months to less than 1 --gt; 5 days
gt; - From 1 to Less than 5 --gt; 10 days
gt; - From 5 to less than 12 --gt; 5 days
gt; - From 12 to 20 --gt; 20 days
gt;
gt; This situation is a challenge because in the cell B1
gt; - I need to determine the number of year/months/days based on today's date
gt; compared to the HIRE DATE in A1
gt; - I need to have several quot;ifquot; condition tested at the same time
gt;
gt; Can someone help?
gt;
gt; Thanks so much
gt;
gt;
gt;
Michel --

Here's one approach:

=IF(TODAY()-A1lt;182,0,IF(TODAY()-A1lt;365,5,IF(TODAY()-A1lt;1825,10)))

Basically, you create a set of quot;nestedquot; if-statements in which you put the
next if-condition into the false part of the previous if statement. I didn't
do the last two parts, mainly out of laziness but also so you could practice
it out on your own.

HTH

quot;MIchel Khennafiquot; wrote:

gt; Good evening Excel Gurus
gt;
gt; In a situation where I want to determine the number of vacation days an
gt; employees would have...
gt;
gt; In A1 I have the hire date
gt; In B1 I want to determine the number of days of vacation the person may have
gt; using the following conditions:
gt; - From 0 to 6 months --gt; 0 Days
gt; - From 6 months to less than 1 --gt; 5 days
gt; - From 1 to Less than 5 --gt; 10 days
gt; - From 5 to less than 12 --gt; 5 days
gt; - From 12 to 20 --gt; 20 days
gt;
gt; This situation is a challenge because in the cell B1
gt; - I need to determine the number of year/months/days based on today's date
gt; compared to the HIRE DATE in A1
gt; - I need to have several quot;ifquot; condition tested at the same time
gt;
gt; Can someone help?
gt;
gt; Thanks so much
gt;
gt;
gt;
gt;