Hi, I got the type mismatch error in the CDAT function if the date format is 'dd-mmm-yyyy' in french.code is : cdat("1-juil.-2012") give me type mismatch. Please help.................................... many thanks