I would like to manipulate dates in an excel worksheet (that is avoiding VBA,
I guess i could accomplish my goal with VBA) in a way that would make my
worksheet work in every excel localization. Unfortunately I need to use
formatting such as TEXT(C1, "ddd") (short day name) which works fine in
english.... but will produce a cell containing ddd in french, italian, german
and possibly many other locales. Unlike VBA, excel does not translate this
kind of strings....
Similarly, when I use DATEVALUE the date needs to be in mm-dd-yyyy format in
US and UK, while it's dd-mm-yyyy in other countries; I guess VBA can take
care of that too, but....

Is there a "universal" date format that is recognized by every localization
and can therefore be used in every date-related function??

Thanx for your input....