ExcelBanter - MAX formula and 'empty fields'

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MAX formula and 'empty fields' (https://www.excelbanter.com/excel-discussion-misc-queries/200558-max-formula-empty-fields.html)

David Brereton[_2_]

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.

Dave Peterson

MAX formula and 'empty fields'

=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

All times are GMT +1. The time now is 04:39 AM.