Skip to main content
Solved

Convert multiple dates in one cell into multiple months in another

  • September 29, 2023
  • 2 replies
  • 29 views
A
Forum|alt.badge.img+3

If I have one date in a single cell, then I would use the formula 

DATETIME_FORMAT({}, 'MMMM) to convert that date into a month. 
 
However, sometimes when using a Look Up I'm pulling multiple dates, separated by commas, into one cell. I'd like to find a formula that will convert all of these multiple dates into the month equivalent. So solving the 'error below'.
 
 

Any help much appreciated. Thanks. 

Best answer by Sho

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.

    2 replies

    S
    Forum|alt.badge.img+21
    • Sho
    • Inspiring
    • Answer
    • September 29, 2023

    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.

    A
    bnaner
    A
    Forum|alt.badge.img+3
    • artichokejoe
    • Author
    • New Participant
    • September 29, 2023

    Fantastic. That's worked. Thank you. 

    Terms & ConditionsAccessibility statement