Auto update date field in table


I have a date in my table, lets say this is the last date in the month of November. After this date has past, I would like some form of automation to run, that updates that date from November, to the last date in December. And then so on and so on…

How could I achieve this?

Figure out the month using current date and find the last date of that month.
You can even use custom js to achieve that.