Year and month formula

[Ratso]

Hi,

I hope someone can help?

I have the below formula that was working pretty well until the change of year

=YEAR(TODAY())&MOD(TEXT(MONTH(TODAY()),"dd")-2,12)+1

This gives me a result of 201912.

The problem is that it should read 201812 as I need to go one month back from January 2019. (December 2018)

Any suggestions?

[jason.b75]

Try

=TEXT(EOMONTH(TODAY(),-1),"YYYYMM")

[Ratso]

Thanks Jason.b75

Gawd knows where I got mine from seeing that yours looks so simple