MIN for dates

[mzmyers321]

I am using the MIN function for dates in two adjacent cells and it is returning 1/0/1900. How can I get the function to return one of the dates in the two cells selected?

 

[shobolos]

Just make sure the cells are correctly formatted as Dates.

If you right click on a cell and select 'Format Cells' the 'Date' category should be already highlighted.

If it is not select it and click 'OK'.

 

[mzmyers321]

It is

 

[deletedalien]

Your source cells are not Dates...

Use Text to columns to convert them to text

 

[AhoyNC]

Most likely your dates are "text" and not actual Excel dates.
You can check with the ISNUMBER function. say your date is in A2 then ISNUMBER(A2), if it returns FALSE then your dates are text.

To change them to a number try:
-Copy a blank cell
-Then highlight your dates and go to PASTE SPECIAL
-ADD & OK