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.
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.