SOLVED

New Contributor

# Formula to create MONTH is adjacent cell

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

# Re: Formula to create MONTH is adjacent cell

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 (New Contributor)
Solution

# Re: Formula to create MONTH is adjacent cell

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

# Re: Formula to create MONTH is adjacent cell

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