Recherchev date - résultat case vide = 1900/01/00
Manon4046
Posted messages
4
Status
Membre
-
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Hello,
In an Excel file, I have 2 tabs (A and B). When I search in tab B to find the elements that are in A, I get dates 1900/01/00 as a result for empty cells in A.
What should I add to my formula to avoid this result?
I would have liked to attach an example of the table in question, but I don't know how to attach a file to this message.
Thank you.
In an Excel file, I have 2 tabs (A and B). When I search in tab B to find the elements that are in A, I get dates 1900/01/00 as a result for empty cells in A.
What should I add to my formula to avoid this result?
I would have liked to attach an example of the table in question, but I don't know how to attach a file to this message.
Thank you.
