View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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.