Try something like this:

A20: =IF(TODAY()=INT(A10),10,"not due")

Note: I used the INT function in case A10 includes a time value
eg: 4/22/2007 5:00:00 AM

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"SoupNazi" wrote:

Here's another one for those much smarter than me. Cell A10 will have a
static date. If we have reached that date or gone beyond it then I want A20
to equal 10. Any ideas? Thanks for your help.