MS Excel / VBA help thread

You are reading a single comment by @chez_jay and its replies. Click here to read the full conversation.

•

rhb in reply to @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.

•

chez_jay in reply to @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 month

They'll only give the same result on the first of a month Feb-Dec.

•

rhb in reply to @chez_jay

They'll only give the same result on the first of a month Feb-Dec.

Today being 1st March, that makes sense. Ta.

About

Avatar for chez_jay @chez_jay started