UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Auto Display Yes Or No, Office 2013    
 
   
smyeong
post Apr 22 2020, 05:14 AM
Post#1



Posts: 409
Joined: 6-November 02
From: Malaysia


Hi, there
Can somebody help me on this? How can i auto display "YES" on column H if the columnC is today
Display "No" if columnC is not today?

Use data validation? If yes, how can i go about that?

TQ in advacnce
This post has been edited by smyeong: Apr 22 2020, 05:16 AM
Attached File(s)
Attached File  Untitled.png ( 19.48K )Number of downloads: 7
 

--------------------
We should see thing in both side. positive and negative
Pls visit http://ipohtech.blogspot.com for tech solutions around the world..
Malaysia.
Go to the top of the page
 
ranman256
post Apr 22 2020, 06:14 AM
Post#2



Posts: 918
Joined: 25-April 14



=(c2=today())

Oops,I forgot the time. Convert c to date only.
=DATEVALUE(MONTH(A1) & "/" & DAY(A1) & "/" & YEAR(A1))=TODAY()
This post has been edited by ranman256: Apr 22 2020, 06:25 AM
Go to the top of the page
 
smyeong
post Apr 22 2020, 11:09 PM
Post#3



Posts: 409
Joined: 6-November 02
From: Malaysia


hi, raman25
thanks for the input. I still don't know how to manipulate this..can i have some screenshot?
can your formula able to display "YES" or "NO" if that date column is today date or otherwise..


tq

--------------------
We should see thing in both side. positive and negative
Pls visit http://ipohtech.blogspot.com for tech solutions around the world..
Malaysia.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th July 2020 - 04:28 AM