Forum Discussion
Solved
please help me with ensuring DEFAULT DATE is entered in correct format in = IFNA(VLOOKUP(..), DATE..
...set-up or scenario some text in the date fields are as correct in date format and some are inserted as TEXT format. These came from trying to insert a default date when a vlookup did not find ...
In the Formula, replacing "1/1/1900" with Date(0,1,1) should do the trick.
In the Formula, replacing "1/1/1900" with Date(0,1,1) should do the trick.
