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.
|