(see attachment) Ok, what in the EARLIEST DATE field I have the formula MIN(B14:R14). The problem as you can see is that when all the cells in that range have a "-" symbol in there, it reports back as 1/0/1900. I have the EARLIEST DATE column formated to show a date because otherwise it reports a number. How can I get this column to show the "-" symbol is there is no dates in the range or if there are dates, to show the earliest (MIN) one?
Thanks for the help.
Bookmarks