- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 29, 2023 01:13 AM
If I have one date in a single cell, then I would use the formula
Any help much appreciated. Thanks.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 29, 2023 02:12 AM
It's simple.
Add the "DATETIME_FORMAT({}, 'MMMM)" formula field to the Lookup source table.
Then, Lookup it.
If you make it a Rollup field instead of a Lookup field and use ARRAYUNIQUE(), only unique values will be displayed.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 29, 2023 02:12 AM
It's simple.
Add the "DATETIME_FORMAT({}, 'MMMM)" formula field to the Lookup source table.
Then, Lookup it.
If you make it a Rollup field instead of a Lookup field and use ARRAYUNIQUE(), only unique values will be displayed.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 29, 2023 09:33 AM
Fantastic. That's worked. Thank you.
