Hello All!
I am trying to get headings on a spreadsheet using formulas. I have three columns B C and E.
In B3 I have the result Dec-14 from entering the following formula =A1
In C3 I have the result Nov-14 from entering the following formula =DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))
In E3 I would like the result Dec-14 vs Nov-14
I tried =B3&" vs "&C3 which returns 41974 vs 41944 While this is technically what I asked for I cannot get it to format correctly. Changing the cell format doesn't work.
I also tried =TEXT(B3,mmm-yy)&" vs "&TEXT(C3,mmm-yy) which gives me the error #NAME
Any help would be greatly appreciated!
Bookmarks