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?