Hello All,
I really appreciate your help on this.
It may be simple for someone who does this often but I have tried everthing i know and can't get it to work.
My last resort will be a new column with a lookup pulling the name of the month from another table.
I am really trying to get away from so many tables and lookups.
Here is my example
There are two columns in my sheet for creation dates.
My goal is to have the text name of the month appear in the second column.
This is as far as i could get with formulas.
Second column formula is just pulling in the month of the first column.
=month(A1)
How do I get the 10 in the second column to read October?
CreateDate creation month
10/1/2014 10
10/21/2014 10
10/21/2014 10
10/30/2014 10
10/30/2014 10
10/30/2014 10
10/30/2014 10
10/30/2014 10
Thank you very much.
Bookmarks