Hello,

What you have suggested solved the "date" problem. But I have a question, as you first suggested with cell=0 and it does not return a value, what ways are there for me to discern whether it showing #Value! when it is an incorrect formula or when it is just not displaying the "return results"?

Many have suggested to use just ,INT(cell) to remove the time and have the date shown but when I do that, it shows #VALUE! despite the formula being correct and all.

THANK YOU~!