Extract Month and Year Dynamically from the Data

[DataPirate26]

Hi all,

Below I have attached one sample Data. Need to Extract the Month and the Year from the data. 

Required Output: April 2023, May 2023, June 2023

[Yoshiro_Fujimori · Accepted solution]

Hi @DataPirate26 ,

How about this formula? I hope this helps.

Formula Tool

Year = GetWord([ team Comments], CountWords([ team Comments])-1)

Month = GetWord([ team Comments], CountWords([ team Comments])-2)

Output = [Month] + " " + [Year]

Output image

[sparksun · Accepted solution]

[binuacs · Accepted solution]

@DataPirate26 One way of doing this

[grazitti_sapna · Accepted solution]

Hi DataPirate26, You can try in following way: