Calculating if today is someone's birthday
 

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

Calculating if today is someone's birthday
 

On Aug 12, 10:17*am, Ged wrote:
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

Parse, or convert to global number from the dates compared to birth
date and use IF function. Maybe use global date excluding year so can
find for next year.

Calculating if today is someone's birthday
 

=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

Calculating if today is someone's birthday
 

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

Calculating if today is someone's birthday
 

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

Calculating if today is someone's birthday
 

Oh right. I have the name in column F, and DOB in M, so i can fix that.
Presumabbly the range have $ in for when I copy it down.

What should the outcome show? I'm just getting #N/A (and i'm using a test
sheet so have fixed the DOB to be today's date (not year, obviously)).

"Bob Phillips" wrote:

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

Calculating if today is someone's birthday
 

I would add a column that just shows the month and day:

=text(a2,"mmm dd")

Then drag down as far as needed.

Then I could filter/sort by this column to see the birthdays I wanted.

Ged wrote:

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

--

Dave Peterson

Calculating if today is someone's birthday
 

Did you array enter it?

--
__________________________________
HTH

Bob

"Ged" wrote in message
...
Oh right. I have the name in column F, and DOB in M, so i can fix that.
Presumabbly the range have $ in for when I copy it down.

What should the outcome show? I'm just getting #N/A (and i'm using a test
sheet so have fixed the DOB to be today's date (not year, obviously)).

"Bob Phillips" wrote:

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

Calculating if today is someone's birthday
 

That's slightly easier!

I'd still like to get the other method to work, just because I'm stubborn.

"Dave Peterson" wrote:

I would add a column that just shows the month and day:

=text(a2,"mmm dd")

Then drag down as far as needed.

Then I could filter/sort by this column to see the birthdays I wanted.

Ged wrote:

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

--

Dave Peterson

Calculating if today is someone's birthday
 

Yes, but i had the columns wrong. Now I get the result 114541 (or 07/08/2213
in date format) on a birthday of 30/11/1938



"Bob Phillips" wrote:

Did you array enter it?

--
__________________________________
HTH

Bob

"Ged" wrote in message
...
Oh right. I have the name in column F, and DOB in M, so i can fix that.
Presumabbly the range have $ in for when I copy it down.

What should the outcome show? I'm just getting #N/A (and i'm using a test
sheet so have fixed the DOB to be today's date (not year, obviously)).

"Bob Phillips" wrote:

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

Calculating if today is someone's birthday
 

Just put an autofilter on the data, then filter for today's date.

Tom

"Ged" wrote:

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

Calculating if today is someone's birthday
 

If you actually filter on today's date (m/d/y), then that would tell you who was
born today--not the people who are celebrating their birthdays today.



TomPl wrote:

Just put an autofilter on the data, then filter for today's date.

Tom

"Ged" wrote:

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

--

Dave Peterson

Calculating if today is someone's birthday
 

Guess I didn't think that through.

"Dave Peterson" wrote:

If you actually filter on today's date (m/d/y), then that would tell you who was
born today--not the people who are celebrating their birthdays today.



TomPl wrote:

Just put an autofilter on the data, then filter for today's date.

Tom

"Ged" wrote:

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

--

Dave Peterson

Calculating if today is someone's birthday
 

Ged wrote:
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
If the dates are in this format: 8/22/2008, 8/22/1999, for example, then
a simple "Find All" and entering 8/22 should locate both dates.

Why complicate matters?

Bill