how do i create a column to show the month only using the date column as a reference

HI, and welcome to the forum.

You can use the formula

=TEXT(A1,"mmm")

where A1 is the value you wish to convert. Or you can select the entire column and format it to return the month.

Jim O