Completed years of service

Excel 902 views 3 replies

Dear Friends,

To calculate Bonus eligibility, I have to find out the number of years of Service for following categories:

 

1. Service Recokned as on 31 Mar 11 - Category #1

2. Service Recokned as on 30 Sep 11 - Category #2 (for employees who joined on or after Sep 10)

 

Criteria Number 1: Persons who have completed more than 1year are eligible for full bonus

Criteria Number 2: Persons in category#2 should have joined after SEp 2009 and should have completed 6 months to 1 year of service @ 30 Sep 2010 so that I can give them a consolidated bonus

Care should be taken that employees who have completed more than 1 year @ 30 Sep 10 should not appear in Category#2, as they will find place in Category#1

Plz help

 

Rajarajan

Replies (3)

U CAN TRY WITH THIS ONE

IF U WANT IN OTHER SENSE PLS TELL

Dear Kankar,

Thank you very much. I am sufficient with this and in need of any more validations I wiil come back

 

V. Rajarajan

CLEAR YOUR CRITERIA.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register