
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2022 08:15 AM
Hi Everyone
Does any one know of a formula that could deduce the Week Number in the Year from a given date field?
Any help would be greatly appreciated.
Stephen
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2022 08:37 AM
Airtable has a WeekNum function that will allow for you to create week numbers. You create a column and make the field type formula and put the formula below.
Ex. WEEKNUM(Enquiry Date/Time)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2022 08:37 AM
Airtable has a WeekNum function that will allow for you to create week numbers. You create a column and make the field type formula and put the formula below.
Ex. WEEKNUM(Enquiry Date/Time)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2022 09:17 AM
Lina, you’re an Angel. I’ll give this a shot when I’m back at a computer. Much appreciated.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2022 11:27 AM
Worked brilliantly. Exactly what I needed. Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 21, 2024 02:04 AM
Thank you for that Lina!
