You don't say how your columns are ordered so I have assumed the date entered
service is column C and locations are column D. I have assumed a location of
Leeds but this could equally be a cell address.

=SUMPRODUCT(--(D2:D10="Leeds"),--(C2:C10G7),--(C2:C10<G8))

The 2 dates you specify are in cells G7 and G8

Mike

"jpreman" wrote:

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.