You should stick with your original thread; I posted a formula there for
you. To save you the trouble of looking for it, here is what I posted back
there...

I think this formula will do what you want (at least my tests indicate it
will)...

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

By the way, I changed the output to match what I think you originally asked
for. My original formula showed the number of days that have passed since
the birthday... I think you wanted the number of days *until* the next
birthday. The above formula shows that number along with the text messages
you asked for. Try it out and let me know if it works correctly and if the
number I now show is what you really want.

--
Rick (MVP - Excel)


"Danny Boy" wrote in message
...
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!