Hello friends, this should be an easy one for someone but I have been having an issue with it for a while. I have a column of "normalized" dates that are each month / 1 / year so each is date formatted and 1/1/2013, 2/1/2013 etc. I want to use a simple month formula for how I use the data in graphs so I'd like to use =MONTH(A2) to return Sep in the attached example but for some reason it keeps giving me Jan. It appears in col B that it is returning the correct # but in col C (pointed it at col B and col A) it is returning J and same in col D. The differences between each of these columns is how I tried to format them. Check the formatting on them and you'll see.
Currently I'm using a lookup formula to a reference table as a workaround but it isn't what I'd like to do.
Thoughts?
Bookmarks