=text(a1,"mm/dd")="12/31"

Nolene wrote:

How would I do this if I wanted to highlight every cell that has 12/31 (Dec
31) for any year in it?

"SteveG" wrote:


DKY,

You don't actually need the IF in your statement. Just use,

=MONTH(TODAY())=7

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=558892



--

Dave Peterson