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!
Hi Elizabeth, like this?
Date(Max(MakeDate(2018,Month(today())-1,1)),'MMM') & ' ' & Year(Today())
May be this
=Date(MonthStart(Max(MakeDate(2018, MonthNum, 1)), -1), 'MMM YYYY')
Yeah that worked.
Thank you very much!
Retrieving data ...