No, I am testing the month and the day, so it should be N each time.

--
__________________________________
HTH

Bob

"Ged" wrote in message
...
Presumably the N1:200 that you have there twice should be M?

"Bob Phillips" wrote:

=INDEX(M1:M200,MATCH(1,(MONTH(TODAY())=MONTH(N1:N2 00))*(DAY(TODAY())=DAY(N1:N200)),0))

where I am assuming the names are in column M, the birthdays .

This is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--
__________________________________
HTH

Bob

"Ged" wrote in message
...
I have a list of names with date of birth, how do I work out if today is
someone's birthday?

It may seem easy just to scan through the list to spot the right day,
but
I've got 15000 lines, so that's not really an option!

Thanks in advance