Good morning from a given column How can I return the month written in full letters to another column?
Example
Column: Date 02/10/2018
Column: Month February
thank God bless you
Hi @Francesco_Santoro Try MONTH([Date])
Sorry but it is normal that this formula ends like this 12? , true, โDecemberโ)
Hi @Francesco_Santoro , yes that is the format of the IFS () expression. I have tested it as well. I request you to try it. Please do revert in case you face any challenge.
Hi @Francesco_Santoro, I also request you to go through the note that was released when this function was introduced.
plus.google.com - IFS() function โ new feature We just added the IFS() function for expressioโฆ
Hope this helps. IFS() function โ new feature We just added the IFS() function for expressioโฆ plus.google.com
One way is the SWITCH expressionโฆ
=SWITCH(MONTH([Date]), 1,โJanuaryโ, 2,โFebruaryโ, 3,โMarchโ, 4,โAprilโ, 5,โMayโ, 6,โJuneโ, 7,โJulyโ, 8,โAugustโ, 9,โSeptemberโ, 10,โOctoberโ, 11,โNovemberโ, โDecemberโ)
hi @Aleksi_Alkio, SWITCH statement is much cleaner, compact expression.
Hi @Francesco_Santoro, To add to guidance given by @Lynn, in case you are looking for months by their names, you may wish to try the following expression,
=IFS( MONTH([Date])=1, โJanuaryโ, MONTH([Date])=2, โFebruaryโ,MONTH([Date])=3, โMarchโ, MONTH([Date])=4, โAprilโ,MONTH([Date])=5, โMayโ, MONTH([Date])=6, โJuneโ,MONTH([Date])=7, โJulyโ, MONTH([Date])=8, โAugustโ,MONTH([Date])=9, โSeptemberโ, MONTH([Date])=10, โOctoberโ,MONTH([Date])=11, โNovemberโ, true, โDecemberโ)
Hope this helps
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |