In calculated properties we need to have an EOMONTH function that can return a date that is the end date of the month we are referring to.
Syntax should and could be the same as in Excel/Google Sheets. In these the syntax for EOMONTH is: EOMON
read more