I want to populate an invoice tracker based on the selection of a start month, billing cycle (Monthly, Quarterly or Annually), & contract term.
There are two potential elements to the invoice – rental charges (invoiced as per the billing cycle) and one off charges (invoiced quarterly i.e. June, Sept, Dec, & March)

Is there an excel formula that can accomplish this? I have attached a sample file
Sample.xlsx