PC Review


Reply
Thread Tools Rate Thread

Dates between two sheets...

 
 
Skeeterj
Guest
Posts: n/a
 
      18th Nov 2008
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.
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      18th Nov 2008
=MAX(HH1:HH5) and format as Date
--
Gary''s Student - gsnu200814
 
Reply With Quote
 
Skeeterj
Guest
Posts: n/a
 
      18th Nov 2008
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

 
Reply With Quote
 
Skeeterj
Guest
Posts: n/a
 
      18th Nov 2008
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

 
Reply With Quote
 
Skeeterj
Guest
Posts: n/a
 
      18th Nov 2008
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

 
Reply With Quote
 
Gary''s Student
Guest
Posts: n/a
 
      18th Nov 2008
=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

 
Reply With Quote
 
Gary''s Student
Guest
Posts: n/a
 
      18th Nov 2008
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Work Sheets with Dates CHerzog Microsoft Excel Worksheet Functions 1 9th Mar 2009 04:47 PM
putting dates on multiple sheets ramona Microsoft Excel Misc 3 9th Jan 2009 04:38 PM
Changing dates on multiple sheets =?Utf-8?B?YW5keWNvMTE=?= Microsoft Excel New Users 3 1st Mar 2007 07:11 PM
Sheets dates,weeks and Months. How do I pano Microsoft Excel Worksheet Functions 9 9th Feb 2007 04:51 PM
Add new sheets with week ending dates =?Utf-8?B?Y290dGFnZTY=?= Microsoft Excel Programming 2 17th Nov 2004 04:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:52 AM.