Thread: IF TODAY equals date in cell A10, or if TODAY is beyond that date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SoupNazi SoupNazi is offline
external usenet poster
  
Posts: 9
Default IF TODAY equals date in cell A10, or if TODAY is beyond that d
Looks like these will work fine. Thanks Barb & Ron

"Barb Reinhardt" wrote:

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