I believe you're saying you'd like to have a list of dates in one column (A)
and a corresponding list of month names in another (B). You could set up a
table of data off to the side or on another sheet which contains the list of
month numbers and month names like this:
Month_Num Month_Name
1 January
2 February
3 March
etc etc
To get the name of the month into column B, you would just VLOOKUP the month
in the table like this:
=VLOOKUP(MONTH(A2),$Y$1:$Z$15,2,0)
This assumes the list of month names is in Y1:Z15.
A better solution to this problem might be to have column B just = column A.
Then format column B as the month name only by going into Format Cells ->
Custom and typing MMMM in the custom format box. Then, column B will
ACTUALLY be the dates, but will LOOK like the month names.
Does that work?
