Previous End of Month

[tchovanec]

I am looking for an expressions that will give the last day of the previous month. Any help would be appreciated, Thank you

[chematos]

Try this in a textbox and select a Month:

=MonthEnd(AddMonths([Month],-1))

[#3 · Accepted solution]

=MonthsEnd(1,today(),-1)

The first parameter depend your default format