# Formula Help

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

#### Peter Bartholomew

##### Well-Known Member
Something like
= IF( MONTH(dob)<>MONTH(today), " ",
IF(DAY(dob)>DAY(today), " ",
IF(DAY(dob)=DAY(today), "Happy Birthday ",
(DAY(today)-DAY(dob)) & " days to go")))

or a function I have never used before
= IFS( MONTH(dob)<>MONTH(today)," ",
DAY(dob)>DAY(today)," ",
DAY(dob)=DAY(today), "Happy Birthday ",
TRUE, (DAY(today)-DAY(dob))&" days to go" )

#### Jet Fusion

##### Member
Something like
= IF( MONTH(dob)<>MONTH(today), " ",
IF(DAY(dob)>DAY(today), " ",
IF(DAY(dob)=DAY(today), "Happy Birthday ",
(DAY(today)-DAY(dob)) & " days to go")))

or a function I have never used before
= IFS( MONTH(dob)<>MONTH(today)," ",
DAY(dob)>DAY(today)," ",
DAY(dob)=DAY(today), "Happy Birthday ",
TRUE, (DAY(today)-DAY(dob))&" days to go" )
Thank you will try them out