bi-weekly occurrence within given range

[Giofan]

Hi,

I am setting up a family budget planner, and want to list the fixed outgoings (Description / Amount / Frequency [Monthly / Weekly / Bi-Weekly] / First Date Taken. The variable outgoings, I want to list in a separate table (Date / Description / Amount).

The problem I am having is as follows:

If I pay a window cleaner every two weeks, starting 01/01/18, how do I calculate how much money is spent on window cleaning in each month of the year?

I am happy to change the way I set the budget planner to accommodate this, and am looking forward to your suggestions.

Thanks

Giofan

 

[JLGWhiz]

Hi,

I am setting up a family budget planner, and want to list the fixed outgoings (Description / Amount / Frequency [Monthly / Weekly / Bi-Weekly] / First Date Taken. The variable outgoings, I want to list in a separate table (Date / Description / Amount).

The problem I am having is as follows:

If I pay a window cleaner every two weeks, starting 01/01/18, how do I calculate how much money is spent on window cleaning in each month of the year?

I am happy to change the way I set the budget planner to accommodate this, and am looking forward to your suggestions.

Thanks

Giofan

In my personal budget monitor, I just use monthly averages, because I know that things like utilities can vary. some months are a little over, while others are a little under, but I track the over all with a rolling average which lets me know if I am winning or losing at the end of the month for the total budget. If you try to tie it down to a precise number, it can be very frustrating.