Capitalizing the first letter of a formatted date

[eirikdaude]

I want to use VBA to capitalize the first letter of a formatted date. To give an example, when I put

? format(#1/1/2023#, "Ddd", vbMonday, vbFirstFourDays)

into the immediate window, I want it to output "Sø.", but what I get is "sø.". In a perfect world I'd want it to be a three-letter truncation instead of having the period at the end, but that's not as much of a deal as the first letter being lowercase.

Whether format or some other function is used for the task doesn't matter, but I don't want to need an intermediary step, ideally.

 

[eirikdaude]

And as I post the thread, I remember about StrConv...

? strconv(format(#1/1/2023#, "Ddd", vbMonday, vbFirstFourDays), vbProperCase)

does what I want, but if someone has a more elegant way of doing this please let me know!

 

[JvdV]

Elegant enough. But to retrieve the 3 leading chars, maybe use:

? Left(strconv(format(#1/1/2023#, "dddd", vbMonday, vbFirstFourDays), vbProperCase),3)