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

hello all,

this is my first post ever so im kind of nervous. after reading other threads, my questions seems basic!
i have a spreadsheet with a column showing dates (dd/mm/yyyy). i need the column next to it to display the month only (Jan,Feb etc).
can anyone help with and appropriate formula?

thanks

Monz

Welcome to the Forum.

Assuming your dates are in column A, starting with A2, then put this formula in B2:

=TEXT(A2,"mmm")

then copy down. If you want the full month name then use "mmmm" in the formula.

Hope this helps.

Pete

Thanks Pete!

you have been a great help!

Monz

Originally Posted by Monz

Thanks Pete!

you have been a great help!

Monz

As that was your first thread, you may not be aware of the other things expected of you. You should mark the thread as Solved if you consider it to be so - to do this, click on Thread Tools above your first post. Also, you can thank others that have helped you (not only in this thread) by clicking on the "star" icon in the bottom left corner of any post that you have found to be helpful - this adds to the posters' reputations (the green bars visible in the profiles).

Hope this helps.

Pete

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