
For instance, if start date is 01.02.2022 and end date is 01.02.2023 and if 'frequency' is bi-weekly, the flow will create 24 recordsNot really. As you say later on it is closer to 26 or even 27.
You will be much better off using a fixed calendar table that clearly indicates the dates for your weekly, half-monthly and monthly schedules.
BTW, "Bi-Weekly" is an ambiguous term.