IF TODAY equals date in cell A10, or if TODAY is beyond that date
Enter in A20:
=10*(A10<=TODAY())
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"SoupNazi" wrote in message
...
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.
|