Jet Fusion
Member
Hi
If I have a date in A1 and in B1 this formula =IF(MONTH(E9)<>MONTH(TODAY())," ",IF(DAY(E9)<>DAY(TODAY())," ","Happy Birthday "))
How do I change the formula to add days remaining if it's not yet day for birthday because atm it shows blank if it's not birthday yet.
If I have a date in A1 and in B1 this formula =IF(MONTH(E9)<>MONTH(TODAY())," ",IF(DAY(E9)<>DAY(TODAY())," ","Happy Birthday "))
How do I change the formula to add days remaining if it's not yet day for birthday because atm it shows blank if it's not birthday yet.