I have a list of employees with seniority dates. We inspect the employee's
work each year based upon their anniversary date. I want to sort the dates
so that the list is grouped by common months. For example an employee with
an anniversary date of July 10, 2001 would be grouped with an employee having
an anniversary date of July 2, 2009 even though there are many employees that
do not have an anniversary in July but do have seniority that falls between
the two dates. [EXAMPLE: February 1, 2005]

In other words, all July dates would be grouped regardless of the year, all
February dates grouped regardless of the year etc. I am guessing I will be
using the Date Function and replacing the €œyear€� part with a set value but I
have not been able to make it work. Even after looking at the results of a
Google Search.


Thanks!

Quin