Birthday Reminders

I have a total of 15K names including their birth date

Now I want to create a where 5 days before the birth date it creates a reminder that its time for me to process the greeting card.

I'm having hard time and already wasted my time searching the date. The challenge was the date having the year.

Anyway, here's what I want to achieve.


Date1: 04/7/1981
Date2: 03/29/1980
Date3: 12/02/1985

Output from Date1 should be "Process Greetings". This was calculated by if Date1=Curent Date+5. My problem here is because the year of the date was included in the calculations.
Output from Date2 should be "past due celebrant"
Output from Date3 should be "December celebrant"

Will appreciate everyone feedback.

Try this

Please Login or Register  to view this content.

@Azumi.. Tried downloading this but can't. Probably something wrong with my permission.

@Ali... Im getting error on the EDATE part. Can help to fix?

The formula runs fine for my computer, If others try to run it. For TEXT formula,The second part of formula formation is changeable according to Office Language. Check again, that part.

For example English version

TEXT(A1,"mmmm")

Turkish version

TEXT(A1,"aaaa")

Pls find the file attach :

https://www.dropbox.com/s/66sasr8c9s...nder.xlsx?dl=0

@Azumi. I actually created my own formula, but found some discrepancy due to leap year i guess. And I tried yours and was really awesome and exactly what I wanted.

@Ali. really appreciate your effort.

Glad many are wiling to help.