MONTH({Date of Expense})

Appreciate it. I don’t see a way in formatting for it to display the word for the month. I can only get it to show “1” for January, “2” for February, etc.

Sorry for the bother if this is really simply. I’m not the best at this stuff.

Is that all you want, just the spelled out name of the month? Or do you want both the name of the month and the number?

If all you want is the name of the month, you’d use this:

DATETIME_FORMAT({Date of Expense}, 'MMMM')

But I have a feeling you will want to concatenate that with a number (and probably a number with a leading “0”) so that sorting your categories arranges them in calendar order, rather than alphabetical order.

I just wanted it to show the name of the month, so that I can add a secondary grouping by month for his expenses. Appreciate the help. Trying to learn this stuff.

Yes, i’d like it to sort in Calendar order.

How would I do that? Here is a link to the table (with some example entries to illustrate the sorting.

I think this should work:

MONTH({Date of Expense})


& " "


& DATETIME_FORMAT({Date of Expense}, 'MMMM')

Airtable seems to sort them properly based on the month number without the need for a leading “0”.

MONTH({Date of Expense})


& " "


& DATETIME_FORMAT({Date of Expense}, 'MMMM')

That seemed to work for me. I’m guessing there’s no way to not actually show the 1, 2, 3 etc in front of the Month. That’s definitely not a big deal though. This should be enough to get him going and make it faster to log expenses than his current method.

Thanks!!