Thanks to you all - your formulas worked perfectly!

"birdgirl31" wrote:

I have a column with dates. I want to put a cell with a formula beside each
date that will return the month. I know I can do this with formatting but I
want to use the "month" column in a pivot that will let me sort my data by
month. When I just return the date value and change the formatting to show as
month, the pivot still reads the "month" cells as a day.