Month Formula

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.

 

Sravan_Kumar_0-1585808446962.png

 

Best Answers

  • VIGNESH.M
    Answer ✓

    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
    Answer ✓

    HI@Sravan_Kumar 

     

    Yes, like @VIGNESH.M say

     

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

     

    Panji_0-1585814935997.png

     

    Regards,

Answers

  • Hi @Sravan_Kumar 

     

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

    Panji_0-1585809958188.png

    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

     

    Panji_1-1585810077537.png

     

    regards,

     

    Panji

     

     

  • 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.