Auto monthly due date update

[macjr911]

If my bill is due April 15 2020, so when date is April 16, 2020,  I want the cell to auto change to May 15 2020. and evry month after that

[#2]

Hi,

Try this formula - =DATE(YEAR(A2),IF(DAY(A2)<=15,MONTH(A2),MONTH(A2)+1),15)

Assumption made: 

1. Bill date (from the 1st day of month to 15th day of month) - Due date falls on 15th day of the same month

2. Bill date (from the 16th day of month to month end) - Due date falls on 15th day of the next month

3. Assume A2 cell contains the Bill date.

[#3]

Thank you.

[#4]

Hi so i need to set an automatic yearly renewal date. the lease ends 01/01/2022 and I have set if renew column state 'yes' the renewal date is automatically increased by a year. if 'no'. it does not renew