Forum Discussion
Date Formatting
I have a series of cells with a vlookup formula which either returns a date (if the lookup table has a date) or a blank. This works fine. I am trying to pick up the value of that cell and return a co...
Thanks Haytham, but I am afraid it does not work. Although the cell appears to be blank, If I ask for the LEN(cell ref) I get "01/01/1900". I have tried using that in the formula, but that does not work either.
The lookup formula works perfectly to either display a date or a blank cell, but I need to identify if it is displaying a date then another cell gets to show a code letter.
Regards
Ernie
As a comment, it looks like misprint is here
LEN(cell ref) I get "01/01/1900"
it shall be "00/01/1900" (if dd/mm/yyyy format), other words LEN(cell ref) returns 0.