Simple Excel Text Date

[Andyaf]

Hi,

I need some help on a simple project I'm working on involving dates. The excel sheet is attached. In the first collum, I have a list of dates. In the second column, I have a formula that pulls only the month from the original date in the first column.

Here's where I need help. In the thrid collum, I need the text of the date (ie: "April", "May") not in number format.

Does anyone know how this can be done? The paste values formula won't work, this has to be done automatically.

Thanks for the help!

-Andrew

 

[Debraj]

Hi andyaf..

try this..

=TEXT(B3,"mmmm")

 

[oldchippy]

Hi,

Try this

=TEXT(B3,"mmmm")

 

[Andyaf]

Hi andyaf..

try this..

=TEXT(B3,"mmmm")

Fantastic! Thanks Debraj

 

[Andyaf]

Hi,

Try this

=TEXT(B3,"mmmm")

Perfect! Thanks oldchippy

 

[oldchippy]

We were both glad to help ....... at the same time

 

[Debraj]

and with exactly same formula..