Excel most recent date formula problem

[Jim P]

I am trying to find a formula where once I enter different dates (classes
taken), the most current date will always rise to the top line. Also is there
any certain way I must write the date?

I appreciate any help. Thank You.

 

[Kassie]

=MAX(Nr1, Nr2, Nr3) or =MAX(DateRange) should do the trick for you? Format
as date would make them all appear the same way.

 

[Jacob Skaria]

Dear Jim

If column A contains date use formula =MAX(A:A) to get the latest date..

For formatting select the entire Column. Right click - Format Cells - Date.
Select the format you require. To type in current date press Ctrl+semicolon

If this post helps click Yes

 

[Jim P]

Thanks for the assist, unfortunately, it was not quite what I needed. I need
to have the most recent date auto move to the top of the listing after
hitting "Enter", not just find the latest date, as the latest date would be
inputted on the bottom line.

 

[Jim P]

Jacob...thanks for the reply. It was not quite what I actually needed. After
I input info of the bottom line, and hit "Enter", I need that line to move to
the top of the page.