You're right, it doesn't work here either.
Actually it is even worse. If you want a format such as Mon 12 May, you have
to use =TEXT(A1,"aaa dd mmmm"). Now how good is that? Nice idea, but a
totally useless implementation IMO, in true MS fashion.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Rick Rothstein (MVP -
VB)" wrote in
message ...
Actually, we do not appear to have oooo for month, at least I couldn't get
it to work. Hmm, but if we did, not having one for year didn't occur to
me. Maybe Microsoft started to try providing an method for
internationalizing, started with aaaa and then gave up when they realized
they had forgotten about French Excel's use of 'a' for year (and then
simply forgot to clean up the help files).<g
Rick
"Bob Phillips" wrote in message
...
Even if it does work in French, it is not a panacea as although we have
aaa for day and oooo for month, we don't seem to have anything for year.
Why not, no idea, but that is MS for you.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Rick Rothstein (MVP - VB)" wrote
in message ...
Try this variation on my formula and see if it works (I **think** the
"aaaa"
returns the day name with the localized spelling for the computer it is
being run on)...
=IF(DATE($B$5,$B$4,$B9)<=DATE($B$5,$B$4+1,0), TEXT(WEEKDAY(DATE($B$5,$B$4,$B9)),"aaaa"),"n/a")
...
May work for English and German (and other) regional settings, but I
wonder whether it'd fail for French and presumably other romance
language regional setting where 'a' stands for year.
Internationalization is a PITA.
That is why I'm glad that in my entire programming career, I have never
had to deal with Internalization issues... I have seen some posting
regarding various treatments required to account for it in compiled VB
and it looked like a horrible thing to have to try and deal with
properly. As for the 'a' for year issue, I guess we'll have to wait for
someone with French Excel to try it out.
By the way, for those still reading this thread... the "aaa" and "aaaa"
also works in the formatting patterns for Custom Formatting cells (with
the question about French Excel still pending).
Rick