Me: The cell must contain a 1 or a formula that evaluates to 1
You: Not necessarily.
If you'll review what I wrote, you will see that I addressed the OP's specific situation:
"...will make it to show blanks instead of the 1/1/1900..."
Yes, a 0 will result in 1/0/1900 and a 2 will result in 1/2/1900, but he didn't asked about those dates, he asked about 1/1/1900.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.