Thread: MAX formula and 'empty fields'
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Brereton[_2_] David Brereton[_2_] is offline
external usenet poster
  
Posts: 10
Default MAX formula and 'empty fields'
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.
Reply With QuoteReply With Quote