Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking for an expressions that will give the last day of the previous month. Any help would be appreciated, Thank you
=MonthsEnd(1,today(),-1)
The first parameter depend your default format
Try this in a textbox and select a Month:
=MonthEnd(AddMonths([Month],-1))
=MonthsEnd(1,today(),-1)
The first parameter depend your default format