Anniversary Month How to match

[Quisp]

Ive tried different variations but none work in all scenarios, to calculate Accrued Leave time.
In Column A, I have rows of end of month dates listed.
So A10=1/31/16
a11=2/28/16
a21=12/31/16

Cell A1 has a date of hire date, say, 1/15/16. To complicate things, regardless, of the day in the date of hire, leave does not start until the FOLLOWING month.
So, in the case above where the date of hire is Jan 15, leave and subsequent month anniversary month would be Feb.

What Im trying to achieve is an Alert in addresses B10:B21 where the formula would look at the Month alone in A10, and if it equals the (DOH month(A1) plus one month, which would be Feb), "Anniv Month", otherwise "".

I tried =if(month(a10)=month(a1)+1,"Anniv Month", "") , however, that doesnt work if A1 date of hire is December.

Hope my ramblings make sense.

[BadlySpelledBuoy]

Not sure I've understood completely, but perhaps this in B10 and copied down:

Please Login or Register  to view this content.

BSB

[BadlySpelledBuoy]

Or perhaps this:

Please Login or Register  to view this content.

BSB

[Quisp]

That seems to fix my DOH month=December dilemma. Thanks so much.
Yeah, the DAY and YEAR make no difference in what I was trying to achieve. I just wanted to look at the Month in one cell, and when comparing the month(plus one month) in another cell, if it equals then Anniv Month. Thanks again

[gak67]

You could also try:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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