Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trouble with excel
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: :lol: |
#2
|
|||
|
|||
Does this work assuming the anniversary date in A15?
=IF(DATEDIF(A15,TODAY(),"y")<2,20,22+IF(DATEDIF(A1 5,TODAY(),"y")=5,3,0)) -- HTH RP (remove nothere from the email address if mailing direct) "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: :lol: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel File in Use Notification Missing?? | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel trouble shooting - no gridlines | Excel Discussion (Misc queries) | |||
Trouble with Excel 2000 not calculating/performing formulas | Excel Worksheet Functions |