Apr 12 2020 09:35 AM
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
Apr 12 2020 10:06 AM
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.
Aug 30 2021 03:01 AM