Previous Month Expression

[hammermill21]

I currently have this expression:

=Date(Max(MakeDate(2018,MonthNum,1)),'MMM') & ' ' & Max(Year)

Which shows me the current month and year, but what do I need to add to give me the previous month? I tried adding -1 but that isn't working. Thank you!

[PabloTrevisan]

Hi Elizabeth, like this?

Date(Max(MakeDate(2018,Month(today())-1,1)),'MMM') & ' ' & Year(Today())

[sunny_talwar · Accepted solution]

May be this

=Date(MonthStart(Max(MakeDate(2018, MonthNum, 1)), -1), 'MMM YYYY')

[hammermill21]

Hey Sunny,

Yeah that worked.

Thank you very much!