Excel most recent date formula problem

  • Thread starter Thread starter Jim P
  • Start date Start date
J

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.
 
=MAX(Nr1, Nr2, Nr3) or =MAX(DateRange) should do the trick for you? Format
as date would make them all appear the same way.
 
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
 
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.
 
Back
Top