Hello All

I am looking for a help to create a file in excel which can capture the
exact tenure of people in an organization. Your inputs can help me in
achieving this. 

 

I am looking for a report in which excel can segregate the staff in the
following categories.

 


Name

Date of Joining


Rahul

19-12-2004


Lakshman

22-11-2005


Azhar

01-01-2008


Vinod

01-08-2008

 

 

Through this the end result should be out in this format


Total

Less than 6 months

6 months to 1 year

1 year to 2 years

2 years to 3 years


4

1

1

1

1

 

I would be thankful to all in advance.

 <http://smsxite.com/picdetail.php?catId=43&tid=39> 

Krishna Kishore
 <http://smsxite.com/picdetail.php?catId=43&tid=39> Friendship SMS
    


--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---

<<inline: image001.jpg>>

Reply via email to