recurring Revenue every Nth day of the month regardless of (30/31/28) days.

output (1).xlsx

1. 8/5/2022 and the projection period starts from October 2022. Then the amount will reoccur on 10/1/2022.
2. 8/31/2022 amount will reoccur on 10/31/2022 and next will be 11/30/2022
3. 11/1/2022 amount will reoccur on 12/1/2022 and so on
4. 01/31/2023 amount will reoccur on 2/28/2022 and so on
5. Billing cycle is Monthly, Annually, Bi-annually so need to add values based on that

The recurring amount will be sensitive to (28/30/31) days of the month.

Turning DD into text will make the condition wrong if any value that will be recognized on last day of the month (30/31/2022)

Leaving the solution that worked for this problem "F3=IF(F$2=EDATE($D3,DATEDIF(MIN($D3,F$2),F$2+1,"m")),$C3,0), copy across and down "