View Single Post
 
Old 12-01-2014, 07:23 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I just did a little testing here, and I see that your formula should work if A3 has a date in it. So I'm guessing what it has is a character string. If so, then you can either translate column A to dates, or change your formula to convert TODAY() to a character string in the format matching column A, like this:
Code:
=$A3=TEXT(TODAY(),"m/d/yy")
That works on my machine.