I’ve created a worksheet in calc to manage my expenses. After trial and error I decided to add a matrix in my sheet with one column for each month, containing the amounts to be paid. I’m trying to get the amounts for the current month in the colunmn under “Amount”, but I just cant seem to get the formula right.
Can anyone tell me what I’m doing wrong here?
I’ve added a sample file with sample (fake) amounts. The salary dates are (in my case) once every four weeks) So that’s the reason that in january there are two paydates and I’ve entered a higher salary. Change the date to a week later, and that second date will appear in another month. The amount however is fake. Me real income is only for me to see
To be complete: My Native language is Dutch, and so is my edition of LibreOffice. I’m running LibreOffice under Kubuntu Linux version 18.04