Your correct - my mistake on this with regards to not recognizing "DEC".

check out Stephen Bullens chapter on international considerations for
suggested solutions:

http://www.oaltd.co.uk/ExcelProgRef/ch22/

--
Regards,
Tom Ogilvy


"Mika" wrote in message
ups.com...
Thanks for your interest Tom,

They don't work because those functions accept the argument as along as
it is recognised as a valid expresion of a date, and that I guess is
related to the regional settings... In the non american excel they will
give an error: type mismatch.


what I need is a function that "knows" it always receive and american
date...