Home |
Search |
Today's Posts |
#1
|
|||
|
|||
EXCEL PROBLEM
Hello,
Iam trying very hard to find a fourmula in order to calculate holidays for my employees. The problem is as follow... If they are in the company for less than 2 years they are entitle to 20 days between the 1st of January and the 31st of december If they are in the company between 2 and 5 years they are entitle to 22 days from their anniversary date. If they are in the company for more than 5 years they are entitle to 25 days from their anniversary date. My problem is to take in consideration their anniversary date (ex starting date the 15 of march 2000 how many holidays does this person get?) If anyone could get back to me on this one I will be very gratfull : :lol: :lol: :lol: :lol: :lol: |
#2
|
|||
|
|||
I think your basic problem here is that your definitions are ambiguous. Try
expressing these three rules in logical syntax or draw some venn diagrams and you'll see the issue. Eg, if someone started on 2 January two years ago they become entitled to 20 days on 1 January, and 22 days on 2 January. Perhaps that IS what you mean, but it's an unusal arrangement. "CATHERINE" wrote in message ... Hello, Iam trying very hard to find a fourmula in order to calculate holidays for my employees. The problem is as follow... If they are in the company for less than 2 years they are entitle to 20 days between the 1st of January and the 31st of december If they are in the company between 2 and 5 years they are entitle to 22 days from their anniversary date. If they are in the company for more than 5 years they are entitle to 25 days from their anniversary date. My problem is to take in consideration their anniversary date (ex starting date the 15 of march 2000 how many holidays does this person get?) If anyone could get back to me on this one I will be very gratfull : :lol: :lol: :lol: :lol: :lol: |
#3
|
|||
|
|||
I'm posting this to the EXCEL group to get feedback from there.
"CATHERINE" wrote in message ... Hello, Iam trying very hard to find a fourmula in order to calculate holidays for my employees. The problem is as follow... If they are in the company for less than 2 years they are entitle to 20 days between the 1st of January and the 31st of december If they are in the company between 2 and 5 years they are entitle to 22 days from their anniversary date. If they are in the company for more than 5 years they are entitle to 25 days from their anniversary date. My problem is to take in consideration their anniversary date (ex starting date the 15 of march 2000 how many holidays does this person get?) If anyone could get back to me on this one I will be very gratfull : :lol: :lol: :lol: :lol: :lol: |
#4
|
|||
|
|||
This message doesn't seem to be cross-posted?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Barb Reinhardt" wrote in message ... I'm posting this to the EXCEL group to get feedback from there. "CATHERINE" wrote in message ... Hello, Iam trying very hard to find a fourmula in order to calculate holidays for my employees. The problem is as follow... If they are in the company for less than 2 years they are entitle to 20 days between the 1st of January and the 31st of december If they are in the company between 2 and 5 years they are entitle to 22 days from their anniversary date. If they are in the company for more than 5 years they are entitle to 25 days from their anniversary date. My problem is to take in consideration their anniversary date (ex starting date the 15 of march 2000 how many holidays does this person get?) If anyone could get back to me on this one I will be very gratfull : :lol: :lol: :lol: :lol: :lol: |
#5
|
|||
|
|||
You have posted this in a newsgroup devoted to Word. If you will post in one
of the Excel NGs, you'll be more likely to get a variety of answers. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "CATHERINE" wrote in message ... Hello, Iam trying very hard to find a fourmula in order to calculate holidays for my employees. The problem is as follow... If they are in the company for less than 2 years they are entitle to 20 days between the 1st of January and the 31st of december If they are in the company between 2 and 5 years they are entitle to 22 days from their anniversary date. If they are in the company for more than 5 years they are entitle to 25 days from their anniversary date. My problem is to take in consideration their anniversary date (ex starting date the 15 of march 2000 how many holidays does this person get?) If anyone could get back to me on this one I will be very gratfull : :lol: :lol: :lol: :lol: :lol: |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 mail merge problem | Mailmerge | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Excel Paste Link - Insert row problem | Microsoft Word Help | |||
Link to Excel (Formatting Problem) | Microsoft Word Help | |||
Mailmerge from EXCEL, custom format problem | Mailmerge |