Month Formula

[Sravan_Kumar]

Hi Friends,

I have a list of Fruits and the month that is sold.

Now someone has entered the month in TEXT format 1,2,3,..., 11,12.

I want it to be Jan, Feb, Mar,...,Nov, Dec.

Writing IF-ELSE is a tedious one. I was trying it in that way.

Can you please highlight some easy way.

[Panji]

Hi @Sravan_Kumar 

First you can create custom month and give code 1  to 12

and then in the module you can use format list(Custom Month) to line item Month in Alphabet and then you need to use formula  finditem

regards,

Panji

[Sravan_Kumar]

Thank You Panji for taking your precious time to help.

Please tell me, using this I get the output in List format.

But I want it in Text format.

Can you kindly show me the process.

[VIGNESH.M · Accepted solution]

Hi,

Create a new line item in text format, Use NAME function to convert list format to text format.

Month Alpha Text = NAME(Month Alpha)

~Vignesh M

[Panji · Accepted solution]

HI@Sravan_Kumar 

Yes, like @VIGNESH.M say

You  just need create a new line item and write formula NAME(line item Month alpha)

Regards,