I have a worksheet that I use every month and would like a formula that automatically updates to the previous month.
=TEXT(MONTH(TODAY())-1,"mmmm")
always returns January
.
However, just MONTH(TODAY())-1
correctly returns 11
.
Why then when I format with TEXT()
does it change to January?