dhouston1000,

Say your birthdays are in column C, starting in row 2.

In column D, row 2, use the formula

=IF(AND(DATE(YEAR(NOW()),MONTH(C2),DAY(C2))TODAY( ),
DATE(YEAR(NOW()),MONTH(C2),DAY(C2))<TODAY()+6),"Bi rthday Notice!","")

Take out any line wraps put in by your newsreader, then copy the formula down column D to match your
column of birthdays.

HTH,
Bernie
MS Excel MVP


"dhouston1000" wrote in message
...

I have a worksheet that contains client info including their birthdays.

I would like a column to alert me at least 5 days before their upcoming
bithday so as to contact them about special incentives and offers.


--
dhouston1000
------------------------------------------------------------------------
dhouston1000's Profile: http://www.excelforum.com/member.php...o&userid=26570
View this thread: http://www.excelforum.com/showthread...hreadid=491521