Someone kindly gave me this beautiful formula that creates a countdown to a
members birthday at our fitness club. On the actual birthday, a flag appears
which states "Happy Birthday-Send Letter".

=IF(TEXT(E4,"mmdd")=TEXT(TODAY(),"mmdd"),"Happy Birthday-Send
Letter",(TEXT(E4,"d-mmm-")&(YEAR(NOW())+(TEXT(E4,"mmdd")<TEXT(NOW(),"mmdd" ))))-TODAY())

Is there a way of altering this formula so that the flag "Happy
Birthday-Send Letter" appears between days 10-1, and on the actual Birthday,
the flag changes to "Happy Birthday". This was (as was pointed out to me), we
can send the letter to our member PRIOR to their birthday.

Thanks for the help!

Dan

PS: I posted this earlier, but I fear it got lost among other responses to a
different question!