functions

Hello everyone!!

I need your support to be able to solve the issue that has me stopped.

I need to show the months with debit of the monthly payment concept of each of the clients, which I have already achieved, I only have one detail, when a client registers in the month of March, I want him to take the debits from the month of registration, but with the formula that I have until now, it throws me from January to the current month.

In this example (marked in red) the client signed up in February and returns the month of January, which should only return February and May (months with adequate).

Greetings

 

deudores.PNG

FormulaDeudores.PNG

0 1 76
1 REPLY 1

I can see from your formula if the month is 3 then it will return 1,2,3.  If the month is 6 then it will return 1,2,3,4,5,6.  Please write for each month what you wan the formula to return:

Month 1 = 

Month 2 =

etc

Simon@1minManager.com

Top Labels in this Space