MAX formula and 'empty fields'

[David Brereton]

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]

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

Dates are numbers to excel.