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