Thank you very much

Is there a way to filter to not include certain people? i.e.

Today's Date: 09/09/2008
A B C D
1 Name: Start Date: Number of dates employed: Status:
2 John 11/05/2007 309 Employed
3 Jane 07/09/2007 428 Employed
4 Jacob 07/09/2007 428 No longer Employed
5 Joel 07/10/2006 792 No longer Employed
6 Janet 07/10/2006 792 Employed
7 Joey 07/10/2006 792 Employed

Total number of employees is 6

The solution should now show:

# employed 365 days is 3
# employed 730 days is 2