Function for months name

F

Farhad

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,
 
J

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")
 
S

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

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



JE McGimpsey said:
If the date is in a cell, you can format the cell with
Click to expand...
    Format/Cell/Number/Custom    "mmmm"
Click to expand...
Click to expand...
 
S

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

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

Hope this helps.

Pete
Click to expand...
 
Top