Set The Last Date Of Trandate

You can use the below formula to set the last date of trandate in the workflow triggering after a field change of trandate

(new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).toLocaleDateString()