Completed years of service

Excel 1039 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  

Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details