Forum Discussion
Solved
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,...
Tom McManus Alternatively, just enter =A1 in cell A2 and use the custom format mmmm to display the full month's name.
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