View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
tgcali tgcali is offline
external usenet poster
 
Posts: 49
Default How to change cell contents based on date?

Thank you both so much! Works great!!

tgcali

"Pecoflyer" wrote:


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