Condition if cell contains date
Solved
Valherault
Posted messages
2
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
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
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
It works perfectly! :)
Have a good day.
I mark the topic as resolved
safe travels
best regards