Hi folks!

I usually never get my butt kicked by Excel. More often that not, I
eventually find a go around searching Google.com

Now I'm stumped. ( and frustrated! )

My employer uses SAP as its logistics/production control/management
software. The dates in SAP ( unchangeable by us end users ) are
standard German DD.MM.YY
When I copy from SAP into Excel.....or export from SAP to Excel, this
date format goes along.
Here is a sample screenshot:
http://i15.photobucket.com/albums/a3...lvania/xls.jpg

As you can see, I have a formula ( imbedded If's ) in column J. Excel
didn't recognize this date setup, so I highlighted all, format the
cells to United Kingdom date:
http://i15.photobucket.com/albums/a3...nia/UKDate.jpg

AT first, it looked like the formula worked........But the logic is
false.
here is my formula:
=IF(G4=H4,0,(IF(G4H4,"Released Late","Released Early")))
But Excel isn't looking at the objects in the cells as dates.....but
just the first valus before the first "." period.
In other words, Excel sees 15.04.06 ( 15 April 2005 ) as GREATER than
10.05.06 ( 10 May 06 ).

What do I do? I want to either add/subtract these dates as they
are.....or get Excel to convert these German dates to English format.

What are your thoughts?

Thanks!

Gary in Pennsylvania


--
Gary in Pennsyl
------------------------------------------------------------------------
Gary in Pennsyl's Profile: http://www.excelforum.com/member.php...o&userid=34978
View this thread: http://www.excelforum.com/showthread...hreadid=547172