Anniversary Month How to match

You could also try:

Formula:

=IF(MONTH(EOMONTH(A1,0)+1)=MONTH(A10),"Anniv Month","")

Don't know if this will help with your data layout, but to show the month of the anniversary in a text format:

Formula:

=TEXT(EOMONTH(A1,0)+1,"Mmmm")

This will return 'January' if the month of hire was December, for example.