View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default 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