Check if date before today

[jtbrolly]

Trying to make a formula to see if the dates in a column are before today. Here's the formula I'm using:

=A32<TODAY()[ p CODE]<>  
However, it doesn't seem to be working. Today is the 23rd, so these two are before today, so the formula does not seem to be working. Any ideas?
 
<TABLE style="WIDTH: 115pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=154 x:str><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: yellow; WIDTH: 53pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 height=17 width=71>[FONT=Arial][SIZE=2]9/17/2011[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: yellow; WIDTH: 62pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 width=83 x:bool="FALSE">[FONT=Arial][SIZE=2]FALSE[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 height=17>[FONT=Arial][SIZE=2]9/22/2011[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: yellow; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 x:bool="FALSE">[FONT=Arial][SIZE=2]FALSE[/SIZE][/FONT]</TD></TR></TBODY></TABLE>

 

[VoG]

Try

=A32 < TODAY()

 

[Jose_Chasez]

Assuming dates are in A1 and A2. These should both return TRUE

=A1<NOW()
=A2<NOW()

 

[jtbrolly]

Try

=A32 < TODAY()

Sorry, didn't check my post before I posted. That is the formula I'm currently using. I keep trying to paste it here but it keeps getting messed up for some reason.

 

[jtbrolly]

Is there a way I can attach the file to show you what I mean?

 

[barry houdini]

Possibly your dates are formatted as text - try this tweak

=A32+0 < TODAY()

 

[DeanRobinson]

=AD67<today() seems to work<TODAY() p formatting a not its sure you are me, for works this issue.< issue.<TODAY() from>

 

[jtbrolly]

Possibly your dates are formatted as text - try this tweak

=A32+0 < TODAY()

That was it! Thank you so much!