MS Excel / VBA help thread

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

•

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.

2 Attachments

•

chez_jay in reply to @rhb

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())-1 instead of =MONTH(TODAY()-1)?
•

aggi in reply to @rhb

Interesting bug.

I tend to use eomonth for this kind of date stuff. Seems to be a bit more robust.

About

Avatar for rhb @rhb started