Date Formula

[Dhoang25]

I have a Date column and I want to write a formula that would convert the "date" into the Month that is showing. For example, in column A I have "9/10/2010" and I want column B showing "September" as the month. Please help! Thank you so much!

[JBeaucaire]

Just put in B2:

=A2

...then apply a custom format to that cell/column of mmmm.

[Dhoang25]

I'm sorry for not being clear. I'm trying to create a pivot table that will count for each month. If I use your method above, when I drag column B into "Row Labels" of the Pivot Table it counts each date of the month and not the total Monthly count. What I usually do is sort it out by month and c/p "October" for all rows. As I create a pivot table, it would give me the count for each month.

[SunOffice]

Plz check out the attached, I think it's solved in it. You can apply Month filter/ sorting for ur pivot table too.

[DonkeyOte]

I'm trying to create a pivot table that will count for each month.

If you're using a Pivot you do not need the additional Column - simply "Group" the Date field by Month (& Year if necessary).
http://www.contextures.com/xlpivot07.html

[Dhoang25]

That's awesome! Thanks a bunch!

[Dhoang25]

Donkey,

I'm not sure how to use the Group functionality in Pivot. Can you please walk me through it? I would love to learn something new today! =)

[SunOffice]

Thanks a lot Mr. DonkeyOte for more info!!

It's Awesome!

[LaurenR]

I am trying to do this, and when I select group on my date column in the pivot I get an error- "cannot group this selection." The original data range is formatted as DATE. What am I missing? Thanks!
NEVER MIND- I used your above link to contextures and found a solution! Thanks!