Dates between two sheets...

S

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

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
 
S

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
 
G

Gary''s Student

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

--
Gary''s Student - gsnu200814


Skeeterj said:
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 said:
=MAX(HH1:HH5) and format as Date
Click to expand...
Click to expand...
 
G

Gary''s Student

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