Excel Worksheet 1 is my source data. Excel Worksheet 2 is my "form" I have a cell in Worksheet 2 that references a "date" formatted cell in Worksheet 1. If Worksheet 1 is "blank", I want the cell in Worksheet 2 to return "blank" vs 1900-01-00. The answers I've found online seem not to work. Perhaps as they seem to be 'within the same worksheet'? Help! :)
Solved by S. H. in 11 mins