Condition if cell contains date

Solved
Valherault Posted messages 2 Status Membre -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   -
Hello,

I don't know how to solve my problem, so I will explain it:
my Excel sheet contains several tabs, the first tab has a table with columns (name/location/recovery time/return time/date....), and the following tabs contain various other information.
In my last tab, I have a summary table that retrieves certain information from my different tabs.

I have a cell that retrieves a date from the table in my first tab, and I want this cell to display text when the date shown is a specific date.

For example:
in my summary table, cell A1 contains ='Tab 1'!H29 (which is a date)
I want it to show "Validated" if the date is equal to January 1st, otherwise it should leave the information as it is.

Is this possible? How can I do this?
Thank you for your help.

Configuration: Windows / Chrome 69.0.3497.100

1 réponse

Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
=IF('Sheet 1'!H29=DATE(2018,1,1),"validated",'Sheet 1'!H29)

or if you enter the date in a cell, for example in B1:

=IF('Sheet 1'!H29=$Z$1,"validated",'Sheet 1'!H29)

Best regards

--
The quality of the answer mainly depends on the clarity of the question, thank you!
0
Valherault Posted messages 2 Status Membre
 
Thank you Vaucluse for the quick response.
It works perfectly! :)

Have a good day.
0
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
No problem
I mark the topic as resolved
safe travels
best regards
0