Thread: How to change cell contents based on date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pecoflyer[_17_] Pecoflyer[_17_] is offline
external usenet poster
  
Posts: 1
Default How to change cell contents based on date?

Supposing date is in C41 try in B41 =if(c41<=today(),"yes","waitlist")


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30636

Reply With QuoteReply With Quote