I tried to turn =TODAY() into text using the formula below with today's date being 16/12/2015 in cell A2 but got 'January' as the output month. I was expecting 'December'
=DAY(A2)&" "&TEXT(MONTH(A2),"mmmm")&" "&YEAR(A2)
Output = '16 January 2015'
What have I done wrong?
Bookmarks