Find out who's birthday it maybe today()

**avk** · 06-14-2017, 03:02 PM

If date of birth in column "A"
In column "B2"

Formula:

=IF(ISERR(DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),"d")),IF(AND(DATEDIF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),TODAY(),"d")<=2,WEEKDAY(TODAY(),2)=1),"The last weekend",IF(AND(MONTH(A2)=1,MONTH(TODAY())=12),DATEDIF(TODAY(),DATE(YEAR(TODAY())+1,MONTH(A2),DAY(A2)),"d"),"Not soon enough")),IF(DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),"d")<61,IF(TODAY()-DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))=0,"Happy birthday",DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),"d")),"Not soon enough"))

copy down till your range.

**Excelski** · 06-14-2017, 07:16 PM

Thank you both for taking the time to answer my question, both solutions worked.
i am using avk's solution as it suits my needs better

Thanks again

Kevin