You are reading a single comment by @rhb 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.
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-
You're missing what a date value really is: a count of days elapsed since 31 Dec 1899. And using MONTH was causing your problem.
Right now TODAY() = 45352 (as you'll see if you format as number)
MONTH(TODAY())-1 is equivalent to (current month) -1
MONTH(TODAY()-1) is equivalent to yesterday's monthThey'll only give the same result on the first of a month Feb-Dec.
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.Edit: I'm not entirely clear on your first bit but are you using
=MONTH(TODAY())-1instead of=MONTH(TODAY()-1)?