Gnumeric Date Format (adding day of week string)
This is for the open-source graphical spreadsheet application Gnumeric and I’m on version 1.12.61.
I don’t see this documented anywhere, so I had to experiment until I figured it
out. To get the full name day of the week as a string (e.g. "Monday",
"Tuesday, etc.), you want four Ds: dddd or DDDD (case doesn’t matter). For
abbreviated day of week (e.g. "Mon", "Tue", etc.), use three Ds: ddd or DDD.
Here’s examples with the One True Date Format. As you can see, two Ds give you the numeric day of the month. (For what it’s worth, one 'D' gives you the same thing, but without the leading '0'.)
Format: yyyy-mm-dd
2026-08-17
2026-08-18
2026-08-19
2026-08-20
Format: ddd yyyy-mm-dd ddd
2026-08-17 Mon
2026-08-18 Tue
2026-08-19 Wed
2026-08-20 Thu
Format: dddd yyyy-mm-dd dddd
2026-08-17 Monday
2026-08-18 Tuesday
2026-08-19 Wednesday
2026-08-20 Thursday
Hope that helps someboddy.
I like how fast Gnumeric opens and it has all the features I need in a spreadsheet. I just wish it was easier to find a user manual. The in-application function browser works, thankfully, but it’s short on examples.