Frequency based on start/end date and total number of payments

[L_T]

Hi all, 

I have the below dataset and would like to understand how to calculate the frequency of payments based on the start and end dates, as well as total number of payments that need to occur in that period. Payments occur both on the starting date and end date date. 
For example, the frequency of payments for the first line is monthly, and the frequency for the last line is bi-monthly.

Start Date	End Date	# payments
15/09/2020	15/10/2021	14
27/03/2020	27/01/2023	35
05/05/2020	05/01/2027	60
15/10/2020	15/01/2024	40
05/10/2019	05/08/2026	60
05/11/2019	05/07/2023	23

thanks in advance

[Maskell_Rascal · Accepted solution]

Hi @L_T 

You can use the DateTimeDiff function to calculate the number of weeks between the Start/End dates, and then divide by # payments to get your Payment Frequency. 

Attached is an example workflow. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil