The great thing about dates is that they are just numbers! You don't need to
worry about zeros or empties.
--
Gary''s Student - gsnu200814


"Skeeterj" wrote:

One other quirk with it Gary - I only want the MAX Date if all of the cells
are not empty. If any of them don't have a date yet, I don't want the MAX
Date.

Steve

"Gary''s Student" wrote:

=MAX(HH1:HH5) and format as Date
--
Gary''s Student - gsnu200814