IF function with date condition
Solved
VEROC38
Posted messages
2
Status
Membre
-
bricolom -
bricolom -
Hello,
I have a large dashboard with quite a few formulas in it.
But the one I'm trying to build today is giving me trouble.
In column Z (for example), I want to display an alert type of data (my idea is "LOST" or "TO RECOVER") based on a condition which is a date.
Here's the formula I'm trying:
IF (reference cell >= 04/10/2012, "LOST", "TO RECOVER")
It seems basic but I can't get it to work correctly. It only returns "TO RECOVER" even if the date entered in the reference cell is greater than 04/10/2012.
I should mention that the dates entered in the reference cells are in the date format dd/mm/yyyy.
Thank you for your insights!
I have a large dashboard with quite a few formulas in it.
But the one I'm trying to build today is giving me trouble.
In column Z (for example), I want to display an alert type of data (my idea is "LOST" or "TO RECOVER") based on a condition which is a date.
Here's the formula I'm trying:
IF (reference cell >= 04/10/2012, "LOST", "TO RECOVER")
It seems basic but I can't get it to work correctly. It only returns "TO RECOVER" even if the date entered in the reference cell is greater than 04/10/2012.
I should mention that the dates entered in the reference cells are in the date format dd/mm/yyyy.
Thank you for your insights!
