Thank you,
I don't mean to appear ignorant but where am I entering this formula? When I
add the = with the formula in the cell I get a error.


"Chip Pearson" wrote in message
...
Better to use

If Date = DateSerial(Year(Date),7,23) Then MsgBox "hh"

in case of international date formats.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Don Guillett" wrote in message
...
try
If Date = DateValue("7/23/" & Year(Date)) Then MsgBox "hh"

--
Don Guillett
SalesAid Software

"Digital2k" wrote in message
...
Hello group,

Is it possible to have a pop-up window that reminds me of a birthday or
anniversary etc. I realize Outlook can do this for me but I'm in sales
and I have a spreadsheet with a customer database and sales tracker. It
would be convenient to have that all in one spreadsheet. I'm not an
expert in excel yet, can anyone point me in the right direction?
Thanks,
Digital2k