Share via

Create a Date from a Text string in Sharepoint List

Giuseppe Di Lernia 0 Reputation points
2023-05-25T08:53:00.1266667+00:00

Hi , I have a choice column (text ) with labels representing dates in a format like this:

2022 H1, 2022 H2, 2023 H1, 2023 H2, 2024 H1, etc etc...

Is it possible to create a calculated column that would convert for instance 2022 H1 to 30 June 2022 in a date format?

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 51,986 Reputation points Microsoft External Staff
    2023-05-26T05:37:21.9466667+00:00

    Here is an example for you:

    1.Create a choice column with 2022 H1, 2022 H2, 2023 H1 and 2023 H2 values.

    2.Create a calculated column by using below formula.

    =IF(choice="2022 H1","30/6/2022",IF(choice="2022 H2","12/31/2022",IF(choice="2023 H1","30/6/2023","12/31/2023")))

    3.Result:

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.