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