
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 22, 2021 04:22 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 22, 2021 11:49 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 22, 2021 11:49 AM
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.
