Greetings, Everyone.

I have a sheet that will have dates between, say, 5 columns. (HH1 - HH5).
What I need is on a second sheet's cell, say 'J6', is if the five columns on
sheet one are filled with dates, put the most recent date in sheety two 'J6'.

Any ideas? I've looked at MAX and DMAX. Not sure what else to try.

It's been a long time since programming, but I'm getting back to it.

Thanks.

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

With reference to the sheet? =MAX(sheet2!HH1:HH5)?

Would that work?

Thanks.

"Gary''s Student" wrote:

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

Sorry, went back & looked and realized I didn't say it was also in a separate
worksheet!

So... =MAX([Worksheet1.xls]sheet1!HH1:HH5) ?

Stever

"Gary''s Student" wrote:

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

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

=MAX('C:\Documents and Settings\Owner\My Documents\[Book1.xls]Sheet1'!HH1:HH5)

--
Gary''s Student - gsnu200814


"Skeeterj" wrote:

> Sorry, went back & looked and realized I didn't say it was also in a separate
> worksheet!
>
> So... =MAX([Worksheet1.xls]sheet1!HH1:HH5) ?
>
> Stever
>
> "Gary''s Student" wrote:
>
> > =MAX(HH1:HH5) and format as Date
> > --
> > Gary''s Student - gsnu200814

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