Hi and thanks for reading,

I am not sure of the best way to handle this issue so would welcome your suggestions, please.

The spreadsheet is simply an employee register containing the employee name and start date (as well as many other things).

GROUP A Workers employed after 1st July 2013 are to be given a pay rise in January and then annually on the anniversary of their start date.
GROUP B Workers employed before 1st July 2013 will be given a pay rise in January every year.

On this basis I need to identify the anniversary of GROUP A workers one week before the anniversary to give me time to change their pay rates.

I don't know if the best way is to use conditional formatting, an extra column, have data appear on a second worksheet based on an entered date range or use some sort of VBA code to extract the information.

If needed I can supply a sample workbook but, as I said the only relevant data is the persons employee number, name and start date.

Many thanks