Dates between two sheets...
 

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.

Dates between two sheets...
 

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

Dates between two sheets...
 

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

Dates between two sheets...
 

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

Dates between two sheets...
 

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

Dates between two sheets...
 

=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

Dates between two sheets...
 

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