EOMONTH Function
From Planfix
Returns the last day of the month after adding a specified number of months to the date indicated in the "start_date" argument.
Format:
EOMONTH(start_date;num_of_months)
Examples:
EOMONTH(B;1)