Hi,
I have several columns that contain a series of dates (wthin a row). Not all of the columns will have dates in them (some may be blank). The dates are not in any specific order.
What I need to do is for each row, identify the "earliest" and "latest" dates within the row.
I looked at using the "MIN" function but those cells that are blank return a value of 1/0/1900 so that doesn't work for me in identifying the earliest "valid" date in the row.
Any help/suggestiong are most appreciated
Bookmarks