DATE manipulation Query

  • Thread starter Thread starter Seahorse
  • Start date Start date
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...
 
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
 
Use the formula: =MAX(D8,I3)

Format the cell that contains the formula as a date
(Format>Cells, Number tab)
 
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...
 
Back
Top