Mike Thanks it is working but again one problem that from Jan 01 to 24 it is
not working.

"Mike H" wrote:

There are 2 and it's not the VBA one you want. having checked the correct
one, select the formula cell and tap f2 - Enter

Mike

"Junaid" wrote:

Although i checked the analysis tool but still the name error

"Mike H" wrote:

I should have mentioned if you get a NAME error then you need to load
the analysis toolpak

Tools|Addins - Check the 'Analysis Toolpak'

Mike

On Sun, 25 Jan 2009 09:23:26 +1200, Mike H < wrote:

Hi,

Try this and you get a countdown

=IF(AND(DAY(E4)=DAY(TODAY()),MONTH(E4)=MONTH(TODA Y())),"Happy Birthday
send a
letter",DATEDIF(TODAY(),EDATE(E4,(YEAR(NOW())-YEAR(E4))*12),"d"))

You also may wat to try an additional enhancement. Apply a conditional
format of

Cell value is - Between - 10 - 0
Pick a colour and with 10 day to go the cell turns your colour.

Mike