banner_ad

Completed years of service

Excel for Finance 1064 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
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
16 May 2026
Account & Audit Asst

RAHUL KHANDEBHARAD & ASSOCIATES

Nashik

B.Com

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details