Function for months name

[Guest]

Hi,

is there in excel any function to get the month of a date in a cell and
return the month name like January, Feurary,...?

Thanks,

 

[JE McGimpsey]

If the date is in a cell, you can format the cell with

Format/Cell/Number/Custom "mmmm"

If you really want a function:

=TEXT(<date>, "mmmm")

 

[Saqib]

hi,

let suppose, there is date column and I have to pick up only month from date
column.
I m using =TEXT(<date>, "mmmm") formula but when i copy it down, it gives
the result January, how can i overcome it.

Thanks.....

 

[Pete_UK]

Your dates may not be proper Excel dates - rather, they may be text
values that just look like dates.

Hope this helps.

Pete

hi,

let suppose, there is date column and I have to pick up only month from date
column.
I m using =TEXT(<date>, "mmmm") formula but when i copy it down, it gives
the result January, how can i overcome it.

Thanks.....

If the date is in a cell, you can format the cell with

    Format/Cell/Number/Custom    "mmmm"

 

[Saqib]

Hi Pete,

In both cases whether the cell format is date or text, it gives the result
1. i.e January when i copied the =TEXT(<date>, "mmmm") to other cells.

I repeat my question, suppose there is date column and i have to pickup
month only, when i copy =TEXT(<date>, "mmmm") to other cells and if cell is
blank in date column,the formula gives the result January and i dont need it
January where cell is blank in date column. Pls advise

Date Monty
15-Jul-08 July
January
January


B/Rgds
Saqib

Your dates may not be proper Excel dates - rather, they may be text
values that just look like dates.

Hope this helps.

Pete