Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Evaluate three dates, return the greater date 3

Status
Not open for further replies.
FYRGUY47

FYRGUY47

Technical User
Nov 7, 2008
53
US
Greetings,

In Excel 2002, I need to evaluate three dates in three seperate cells, A1, B1, C1 formatted as mm/dd/yy, and have the greater of the three dates displayed in the forth cell "D1"
Any help would be very much appriciated.

Chris
 
Sort by date Sort by votes
Macropod,

Thanks for the idea and input. I will work on it again next week when I go back to work. Thanks again..

Chris
 
Upvote 0 Downvote
Okay,

Finaly got back to the form today. By changing the =0 to ="" in the earlier formula, that took care of the 01/00/00 result I was getting. This is the formula that works fine now.

=IF(AND('09May12'!G25="",'09May12'!F29="",'09May12'!F35=""),"", MAX('09May12'!G25,'09May12'!F29,'09May12'!F35))

Many Thanks to Skip, & GS for your patients & help on this one. Also thanks to Macropod for your input.

Chris

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
305
SkipVought
S
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
355
EFFEY
EFFEY
ladyck3
  • Locked
  • Question
Excel 365 (2016) Working to auto-populate dates 3
Replies
13
Views
485
ladyck3
ladyck3
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
341
ladyck3
ladyck3
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
707
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top