Determine Previous MonthEnd

[#1]

Hi,

I am interested in an expression that will return the previous month end date. I was able to figure out that MonthEnd(today()) gives the current month's end date. I just want it for the month before instead. Is there an easy way to do this? Thanks.

[#2 · Accepted solution]

try:

=date(monthstart(today())-1)

[eduardo_sommer]

Try this:

=Monthend(MonthStart(today())-1)

Eduardo

[Gysbert_Wassenaar]

monthend(today(),-1)