=if(count(yourrange)=0,"",max(yourrange))

Dates are numbers to excel.

David Brereton wrote:

I am using the MAX formula - ie MAX of a2,a3,a4,a5,a6 etc. ( These are date
fields ) but how do I ensure a blank field is returned if a2-a6 are empty (
rather than 0-Jan-00?

Thanks.

--

Dave Peterson