Thread: IF TODAY equals date in cell A10, or if TODAY is beyond that date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default IF TODAY equals date in cell A10, or if TODAY is beyond that date
A20: If(A10<=today(),10,"")

HTH,
Barb Reinhardt

"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.
Reply With QuoteReply With Quote