Dates between two sheets...

[Skeeterj]

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.

 

[Gary''s Student]

=MAX(HH1:HH5) and format as Date

 

[Skeeterj]

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

Would that work?

Thanks.

 

[Skeeterj]

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

 

[Skeeterj]

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]

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

--
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

=MAX(HH1:HH5) and format as Date

 

[Gary''s Student]

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