SOLVED

Formula to create MONTH is adjacent cell

Copper Contributor

Hi,

I will be making DATE transaction entries when necessary during a month that I am tracking expenses. So say I enter a date in A2 of 8/23/2023, I would like a formula in B2 that would say August, based on the A2 entry, I tried entering =Month(A2) and it returned 8, which is correct but I wanted August.

All help appreciated.

6 Replies

@Tom McManus 

You are on the right track.  There are two obvious design alternatives:

#1 - Use the CHOOSE function:

=CHOOSE( MONTH(A2), "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" )

#2 - Put the month names into a separate area of the worksheet (or on a separate worksheet), and use INDEX or another Excel lookup function:

=INDEX( $K$1:$K$12, MONTH(A2) )

 (where the month names are in chronological order in cells K1 through K12).

 

best response confirmed by Tom McManus (Copper Contributor)
Solution

@Tom McManus Alternatively, just enter =A1 in cell A2 and use the custom format mmmm to display the full month's name. 

@Tom McManus 

If you actually want the formula cell to return text, rather than an 'unusually formatted number', you could use the TEXT function

= TEXT(date, "mmmm")

= TEXT(date, "[$-40C]mmmm")

The second version returns the month in French, just for the sake of it.

Specifying a Language for the TEXT Function (Microsoft Excel) (tips.net)

Thank you
Thank you
Thank you
1 best response

Accepted Solutions
best response confirmed by Tom McManus (Copper Contributor)
Solution

@Tom McManus Alternatively, just enter =A1 in cell A2 and use the custom format mmmm to display the full month's name. 

View solution in original post