You are reading a single comment by @chez_jay and its replies.
Click here to read the full conversation.
-
In
=TEXT(2,"mmmm"), you are getting the month from a date value which represents 2 Jan 1900. Use the actual date value.Edit: I'm not entirely clear on your first bit but are you using
=MONTH(TODAY())-1instead of=MONTH(TODAY()-1)?
chez_jay-
In =TEXT(2,"mmmm"), you are getting the month from a date value which represents 2 Jan 1900. Use the actual date value.
The 2 was derived from date value though? The images are from the Evsluate Formula review steps
Edit: I'm not entirely clear on your first bit but are you using =MONTH(TODAY())-1 instead of =MONTH(TODAY()-1)?
Both gave same result, but turns out MONTH needn't be used.
rhb
This is cooking my brain. I use month = today-1 to get last months name but today this is giving me Jan despite the month value answer being 2 which is correct. Anything obvious im doing wrong?
Edit even month(today()) is giving me 3 in a separate cell, but in this formula gives me 3 that becomes Jan. Weird.