LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Taking a total number of employees that meet certain conditions

I am trying to calculate how many employees have been employed from their
start date to today's date (for example). Then, they need to be categorized
by total number of employees that have worked more than 365 days, 730 days,
etc.

So far, I have the following list:

Today's Date: 09/09/2008

Name: Start Date: Number of dates employed:
John 11/05/2007 309
Jane 07/09/2007 428
Jacob 07/09/2007 428
Joel 07/10/2006 792
Janet 07/10/2006 792
Joey 07/10/2006 792

Total number of employees is 6

The solution should show:

# employed 365 days is 5
# employed 730 days is 3
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If formula with two conditions to meet Carolina Excel Worksheet Functions 7 August 28th 08 05:25 PM
taking conditions from one spreadsheet to another Analyst in the making Excel Worksheet Functions 3 July 3rd 08 12:46 PM
calculate total number of items that meet 2 over multiple sheets twototango Excel Worksheet Functions 5 May 29th 08 07:04 PM
Array to meet conditions Erin Excel Worksheet Functions 5 January 16th 07 08:37 PM
How do I get the total number of items that meet 2 criteria in Exc Terri Excel Worksheet Functions 1 June 28th 06 10:48 PM


All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"