I have a chart with dates on a separate tab and I'm able to pull a date from that chart with criteria and transfer it to my main spreadsheet using the MIN IF function I requested in my last thread. However, if there are no dates at all that meet the criteria on the separate tab I get a "0" result. Formatted as a date, that results in "01/00/00."
Since the ultimate goal is to find the earliest start date out of all the SAT results from both tabs, my formula returns that "01/00/00" and ignores any other dates that I have on my main tab. How do I get the result from the second tab to return nothing rather than a zero if there are no dates to retrieve from the column? Or, how do I get my final resulting formula to ignore the "01/00/00" result?
Bookmarks