Hi all,
Im using these 2 formules to determine the last and current month;
Last; =TEXT(TODAY()-DAY(TODAY());"MMM")&RIGHT(YEAR(TODAY());2)
Current; =TEXT(DATEVALUE(1&B22);"mmm")&RIGHT(YEAR(TODAY());2)
I use these formules to filter data.
Now with changing from 2018 to 2019 it goes wrongl
Last month; Dec19
Current month; Jan19
How can i change the formule that it doesn't automatically take the current year but in case of transition of years it shows Dec18 - Jan19?
Bookmarks