Apr 12 2020 09:35 AM
Apr 12 2020 10:06 AM
Try this formula - =DATE(YEAR(A2),IF(DAY(A2)<=15,MONTH(A2),MONTH(A2)+1),15)
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