View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jpreman jpreman is offline
external usenet poster
 
Posts: 50
Default Counting based on location & dates

Thanks for reading this post.

Have an Excel sheet which includes among others the following column headings;

Employee No
Employee Name
Date of employment
Location
Salary amount

How could I count the number of employees who had joined the service between
two specific dates (eg. 01 Jan 2005 and 01 Jan 2006), for each location.