• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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 :)
 
Top