Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Can custom formatting be applied to columns in Airtable?

Topic Labels: Base design
Solved
Jump to Solution
382 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello
I have converted an Excel spreadsheet into an Airtable base.
In excel, I have columns that are formatted to show [month] & [weeknum] based on a date that is entered.
Is this possible in Airtable?
Kind regards,
Sally

1 Solution

Accepted Solutions

You would need one field for the date, and another field (a formula) to format the date:

DATETIME_FORMAT({Date Field}, "MM ww")

Or you resign to use a single line text field and format the month/week num yourself.

See Solution in Thread

1 Reply 1

You would need one field for the date, and another field (a formula) to format the date:

DATETIME_FORMAT({Date Field}, "MM ww")

Or you resign to use a single line text field and format the month/week num yourself.