How to change cell contents based on date?
 

Hello,

I wanted to know if it's possible to change the contents of cell B41 from
"WAITLIST" to "YES" automatically based on the date entered in cell C41?

I would like the update to occur when the date entered has 'expired'. In
other words, any date that was before or equal to today would show "YES", and
any date in the future would show "WAITLIST".

Is this possible? And does it make a difference if the entry in B41 is a
validation or entered manually? I could easily go either way.

Thank you in advance for any suggestions or tips. You are all always so very
helpful.

tgcali

How to change cell contents based on date?
 

Try this
=IF(C41=0,"",IF(C41<=TODAY(),"YES","WAIT LIST"))

"tgcali" wrote:

Hello,

I wanted to know if it's possible to change the contents of cell B41 from
"WAITLIST" to "YES" automatically based on the date entered in cell C41?

I would like the update to occur when the date entered has 'expired'. In
other words, any date that was before or equal to today would show "YES", and
any date in the future would show "WAITLIST".

Is this possible? And does it make a difference if the entry in B41 is a
validation or entered manually? I could easily go either way.

Thank you in advance for any suggestions or tips. You are all always so very
helpful.

tgcali

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

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