How To Find The Last DATE() Listed

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,A:A)

 

[Minitman]

Greetings

I trying to find the last DATE() showing in a column of DATE()'s. I
am trying to set it up so that the DATE() only displays on the first
instance of that DATE() remains hidden on all repeats of the same
DATE().

What I have so far in A3 is:

=IF(OR(TODAY()=A2,A2=""),"",TODAY())

Also, how do I retain the value of a date that is current or in the
past?

Any help would be appreciated.

TIA

-Minitman

 

[Minitman]

Hey Aladin,

Thanks for the quick response.

I am fairly new at this and was wondering if you could possibly
explain what this code does?

Thanks.

-Minitman

 

[Aladin Akyurek]

It fetches the latest date entry from a range of dates, which I thought you
wanted judging from: "I trying to find the last DATE() showing in a column
of DATE()'s."

 

[Ragdyer]

You're cruel!<bg>

 

[Anderson]

If Lookup can't find the number given it returns the one closest to it.
9.99999999999999E+307 is just a very large number so Lookup will return
the next lowest value to it(your last date if it is the latest date in
the range)

 

[Minitman]

Thank you for the explanations.

I may have misstated my need.

I am looking for a way to automatically add a new date to a column
when I add entries on any row. I am looking for the date and/or time
when I add a number to the third column. If the date is already
present in that column, I want to see only the time (date and time
are in two separate columns, Date in "A" and Time in "B").

I cannot see where to place Lookup to do this.

Any ideas?

TIA

-Minitman