European Dates

**jpnyc** · 08-10-2010, 09:02 AM

Hi, I need to convert - or have Excel understand that the dates in my column are in European date format (dd-mm-yyyy).
I tried;
Format Cell - Date; but it does not have a European format avail.
Format Cell - Custom; but after using a simple formula (=IF(J107>TODAY(),"greater","less")), it is still not seeing the date correctly

Any ideas?

Thanks,
Jason

**ChemistB** · 08-10-2010, 09:21 AM

Can you upload some examples of what you have and, in another column, what you want to see? So the user is entering the dates in European format and Excel is assuming they are in US format? Or they are automatically being imported in European format?

**jpnyc** · 08-10-2010, 09:27 AM

We are downloading a spreadsheet from a Euro company.
I need to analyze the spsh.
For example, in a column of dates I need to see if the date is "greater" then today.
=IF(J107>TODAY(),"greater","less")

The data given is
"4/11/10"

In Europe this is the 4 of November 2010.
Excel is seeing this as as April 11, 2010.

Any ideas.

Thanks,

Jason

**arthurbr** · 08-10-2010, 10:07 AM

Try as follows
select the data range you want to adapt
Click Data - Text to columns - select "Fixed with" - Next - next - in the column data format check Date and set to MDY .Then OK - All should now be adapted

**ChemistB** · 08-10-2010, 10:32 AM

Unless it's initially seeing it as text, I don't think that will work (hopefully it is text). I think you need to convert it to text, then break it apart and put it back together.
Try this in the next column
=DATEVALUE(TEXT(A1,"d/m/yyyy"))
Does that work?