View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Simon[_2_] Simon[_2_] is offline
external usenet poster
 
Posts: 89
Default 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.