You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • 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.

  • Interesting bug.

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

About

Avatar for aggi @aggi started