Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Get oldest date from two columns in Excel
- Thread starter tessam
- Start date
AnotherHiggins
Technical User
Hey, tessam.
Try this:
[COLOR=blue white]=min(A:B)[/color] where your data is in columns A and B - adjust as needed.
This works because of how Excel sees dates. Every date is stored as a whole number - the number of days since 1/1/1900. Today is 38401. Yesterday was 38400, which is less that today's number. Get it?
Post back with any questions.
[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886
Try this:
[COLOR=blue white]=min(A:B)[/color] where your data is in columns A and B - adjust as needed.
This works because of how Excel sees dates. Every date is stored as a whole number - the number of days since 1/1/1900. Today is 38401. Yesterday was 38400, which is less that today's number. Get it?
Post back with any questions.
[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886
- Status