Skip to main content

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

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.

Reply


Terms & Conditions