Thanks stevbriz and Roy -- works perfect
Hank
"stevebriz" wrote in message
ups.com...

Hank wrote:
I am trying to return a dollar amount due if the date in one cell is
greater
than or equal to today. I'm using this formula in an blank cell:
IF(today() = A7 , C7=10,,)

Can't get it to work. Using Excel 2003.

Help please.

Hank
try this
put this formula in C7
= IF(TODAY()=A7, 10,)