DATE manipulation Query

S

Seahorse

I am trying to compare two date and display the value of the later
date.

Lets say I3 is 2-Feb-85 and D8 is 10-Mar-94.

I have tried several variations on the following formula with no
success:

=IF(I3>D8,"=i3","=D8")

In this instance all I see is i3 or D8 displayed. What I actually
want is 10-Mar-94. I know I am buggering up the bit between the
parentheses but playing with brackets etc doesn't help either.

Presume I am missing something fundamental.
---------
Rgds Mike
Remove XXX to reply

Don't play stupid with me, I'm better at it!

WWW.Dead-Fish.Com - Deep Sea Daddies...
 
K

Kevin Carter

hi
try turning both dates to a number then
compare the numbers check for the bigger number and turn it back to a date
value
 
S

Seahorse

D

Debra Dalgleish

Use the formula: =MAX(D8,I3)

Format the cell that contains the formula as a date
(Format>Cells, Number tab)
 
S

Seahorse

Following prompt first aid from the medic Debra Dalgleish
Use the formula: =MAX(D8,I3)

Format the cell that contains the formula as a date
(Format>Cells, Number tab)
Click to expand...

Deborah,

Thanks, works a charm. Now to spend 3 days setting it all up...;)
---------
Rgds Mike
Remove XXX to reply

"There is no sincerer love than the love of food. "
- George Bernard Shaw

WWW.Dead-Fish.Com - Deep Sea Daddies...
 
Top