This is a card in Dave's Virtual Box of Cards.

Gnumeric Date Format (adding day of week string)

Page created: 2026-09-01

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.