| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change date in cell when contents of other cell changes | Excel Discussion (Misc queries) | |||
| How to change data in a cell, based on the date | Excel Worksheet Functions | |||
| Change cell color based on contents | Excel Discussion (Misc queries) | |||
| Change cell in formula based on date | Excel Discussion (Misc queries) | |||
| How do I change the value in cell based on a future date | Excel Discussion (Misc queries) | |||
Linear Mode
