Hi, I am having difficulty with a MAX formula, where I am trying to show the latest date by looking at 3 fields. The issue is that some of the fields do not have any data in, so they are blank, which means that the MAX formula I am using finds no dates and displays the result as 00/01/1900. If this is the case I would like the field to stay blank.
In the e.g. below you will see that in column A I want to display the max date from the columns B,C & D. This works fine where there are dates in B,C & D as in rows 2 & 3, but in row 4 there are no dates in B,C or D but the date in column A shows as 00/01/1900. How can I make it so this is blank?
Excel-MAX.jpg
Thanks for any help!
Steve
Bookmarks