Australian Personal Budget template

[DIKIC07]

I was wondering if someone can help me with a formula for my personal budgeting....

A little background, i break my spreadsheet down into months then i have PREDICTED income and expenses and the same for ACTUAL.

What I'm having difficulties with is, every year i have to work out how many weeks there is in the financial year (in Australia a financial year is, July 1 to June 30 inclusive.) so i can work out how much i will bring in for that month ...

Is there a formula that helps me calculate this?

If so, maybe I'm pushing it here, but i get paid Fortnightly, on a Wednesday. This obviously will impact the amount of money i actually receive for a particular month. Is there a way to incorporate this calculation so its spot on accurate?

[Gregb11]

You say, "how many weeks there is in the financial year". Wouldn't that just be taking the last day of year (June 30, 2020) minus the first day (7/1/2019) and dividing by 7?

[DIKIC07]

How would i put that into a formula ? And also potentially add the calculation based on when i get paid?

My first pay for the 2019/20 financial year is 10/07/2019. I get paid every second Wednesday ...

[Gregb11]

As far as getting the number of weeks, put the start date of the year in one field and end date in another (say A1 for Start and B1 for End). In C1 you could enter:
=(B1-A1)/7.

Not sure I follow on the calculation of pay date. Are you trying to get a formula that would tell you how many paydays you'd have in a given month?

[DIKIC07]

Thats exactly it ... i want to know how many paydays there is in each month so i can workout exactly how much income is coming in for each month. But since every year the day shift, i want a formula of some sort that works this out for me ...

[Gregb11]

To get the number of pay periods in a month, let's say you put the first day of that month in cell A1 (let's say we're doing August, so we'd put in 1/8/19 (d/m/yy). Next, put a pay date (any pay date really, but you can use 10/7/19 (d/m/yy) for this example) in say, cell B1. To get the number of pay periods, in cell C1 in can enter this formula:
=INT((EOMONTH(A1,0)-$B$1)/14)-INT((EOMONTH(A1,-1)-$B$1)/14)
I believe this will give you want you want.

[DIKIC07]

Sorry for the delayed response, I've been away.

That formula definitely helps. It doesn't do all the work but it at least cuts the workload in half. Much appreciated.