I have column B to determine the months of the date column A.
So I used =IF(A2="","",MONTH(A2)) and formatted the cells in column B to show mmmm under custom setting.
However, I am then getting January for all the entries whatever the date happens to be.
Can someone please correct my formula?
Thanks.
Bookmarks