public static Double calcDateValue( String dateString )
	{
		String[] formats = {
				"MM/dd/yyyy HH:mm:ss",
				"MM/dd/yy HH:mm:ss",
				"MM/dd/yy",
				"MM/dd/yyyy",
				"MM/d/yyyy HH:mm:ss",
				"MM/d/yy HH:mm:ss",
				"yy-M-d hh:mm:ss a",
				"yy-M-d HH:mm:ss",
				"yy-M-d hh:mm a",
				"yy-M-d HH:mm",
				"dd-M-yyyy hh:mm:ss a",
				// 10
				"dd-M-yyyy HH:mm:ss",
				"dd-M-yyyy hh:mm a",
				"dd-M-yyyy HH:mm",
				"dd-MMM-yy hh:mm:ss a",
				"dd-MMM-yy HH:mm:ss",
				"dd-MMM-yy hh:mm a",
				"dd-MMM-yy HH:mm",
				"yyMMdd",
				"MM/d/yy",
				"MM/d/yyyy",
				// 20
				"yyyy/MM/dd",
				"d-MMM-yy",
				"d-M-yy",
				"d-M-yyyy",
				"dd-MMM-yy",
				"dd-MMM-yyyy",
				"dd-M-yyyy",
				"dd-MM-yy",
				"dd-MM-yyyy",
				"d-MMM-yyyy",
				// 30
				"d-M-yyyy",
				"d-MMM-yyyy",
				// 32 really is d-MMM but inorder to match, must append year
				"d/MMM/yyyy",
				// 33 really is d/MMM but in order to match, must append year
				"M-yy",
				"MMM-yy",
				"M/d/yyyy",
				"M d, yyyy",
				"yyyy-MM-dd",
				"yy-M-d",
				"yyyy-MM-dd",
				"MMyy",
				"yyMM",
				"yyyyMMddHHmm",
				"yyyyMMddHHmmss",
				"yyMMddHHmmss",
				"MMDDHHmm",
				"MMMM dd, yyyy",
				"E, MMM d, yyyy",
				"E MMM dd, yyyy",
				"EE, MMM dd, yyyy",
				"E, MMMM d, yyyy",
				"E, MMMM dd, yyyy",
				"EE, MMMM dd, yyyy",
				"hh:mm:ss a",
				"HH:mm:ss",
				"hh:mm a",
				"HH:mm",
		};
		for( int i = 0; i < formats.length; i++ )
		{
			try
			{
				String ds = dateString;
				if( (i == 32) || (i == 33) )
				{ // then must add year to date
					GregorianCalendar calendar = new GregorianCalendar();
					int curyear = calendar.get( Calendar.YEAR );
					if( i == 32 )
					{
						ds = dateString + "-" + curyear;
					}
					else
					{
						ds = dateString + "/" + curyear;
					}
				}
				//SimpleDateFormat format= new SimpleDateFormat(formats[i], Locale.ENGLISH);	// 20090701 KSC: apparently need Locale -- why now though??
				//format.setLenient(false);
				WorkBookHandle.simpledateformat.applyLocalizedPattern( formats[i] );
				WorkBookHandle.simpledateformat.setLenient( false );
				//Date d= format.parse(ds);
				Date d = WorkBookHandle.simpledateformat.parse( ds );
				return DateConverter.getXLSDateVal( d );
			}
			catch( Exception e )
			{
			}
		}
		return null;
	}