function bar for C3 cell to equal C2 cell

[data808]

I have a cell C3 that is a date formatted cell like this: mm/dd/yy

I would like cell C2 to only pull the month from that C3 cell and spell out the whole word. I been typing in the function bar like so:
=format(range("C3), "mmmm" and its not working cause it thinks its a formula from the equal sign but I don't know what else to use.

Can anyone help me with this? Thanks.

 

[kevin9999]

=Text(C3,"mmmm")

 

[data808]

=Text(C3,"mmmm")

Thanks @kevin9999. I knew it was something simple. I wanted to try something else and maybe you would know how to do it. It's for the same spreadsheet. So now I typed the formula you gave with a little more in the C2 cell:

=TEXT(C3,"MMMM")&" - "&TEXT(E3, "MMMM")

So C3 and E3 are showing a work week dates with C3= Monday and E3= Friday dates in this mm/dd/yy format. Now C2 reflects as December - January if the dates go into the next month. If the week dates are for the same month it says December - December.

Is there a way to only show one date if the week dates are for the same month?

 

[kevin9999]

Thanks @kevin9999. I knew it was something simple. I wanted to try something else and maybe you would know how to do it. It's for the same spreadsheet. So now I typed the formula you gave with a little more in the C2 cell:

=TEXT(C3,"MMMM")&" - "&TEXT(E3, "MMMM")

So C3 and E3 are showing a work week dates with C3= Monday and E3= Friday dates in this mm/dd/yy format. Now C2 reflects as December - January if the dates go into the next month. If the week dates are for the same month it says December - December.

Is there a way to only show one date if the week dates are for the same month?

Probably, but I'm away from my laptop for a while.

 

[data808]

Probably, but I'm away from my laptop for a while.

Ok well thanks for the first solution. Worked like a charm.

 

[kevin9999]

Ok well thanks for the first solution. Worked like a charm.

I will look at it in a few hours time

 

[data808]

I will look at it in a few hours time

Thank you sir. Appreciate it!

 

[kevin9999]

Try this:

=IF(MONTH(C3)=MONTH(E3),TEXT(C3,"mmmm"),TEXT(C3,"mmmm")&" - "&TEXT(E3,"mmmm"))

 

[data808]

Try this:

=IF(MONTH(C3)=MONTH(E3),TEXT(C3,"mmmm"),TEXT(C3,"mmmm")&" - "&TEXT(E3,"mmmm"))

I'm getting an error. It's reflecting #VALUE! after I plug in your code into the function bar. Says a value used in the formula is of the wrong data type. Sorry, also forgot to mention that C2 cell is a merged cell with D2 and E2 if that makes a difference.

 

[kevin9999]

I'm getting an error. It's reflecting #VALUE! after I plug in your code into the function bar. Says a value used in the formula is of the wrong data type. Sorry, also forgot to mention that C2 cell is a merged cell with D2 and E2 if that makes a difference.

The merged cells wouldn't cause that. The value in E3 might not be a date? Possibly a text value?