Is there a formula that will return only the month from a date?
 

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.

Is there a formula that will return only the month from a date?
 

Use formula = month(A1)

"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.

Is there a formula that will return only the month from a date?
 

If you want the month name:

Short name format: Jan

=TEXT(A1,"ddd")

Long name format: January

=TEXT(A1,"dddd")

--
Biff
Microsoft Excel MVP


"birdgirl31" wrote in message
...
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.

Is there a formula that will return only the month from a date?
 

Ooops!

Short name format: Jan
=TEXT(A1,"ddd")
Long name format: January
=TEXT(A1,"dddd")

Those formulas will return the weekday. These are the correct formulas:

=TEXT(A1,"mmm")
=TEXT(A1,"mmmm")

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
If you want the month name:

Short name format: Jan

=TEXT(A1,"ddd")

Long name format: January

=TEXT(A1,"dddd")

--
Biff
Microsoft Excel MVP


"birdgirl31" wrote in message
...
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.

Is there a formula that will return only the month from a date?
 

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.

Is there a formula that will return only the month from a date?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"birdgirl31" wrote in message
...
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.