Monthly functions in Excel

[Eoghan]

I have a spreadsheet that tracks my monthly salary.
At the end of the month I save it as next months spreadsheet and rename it.
I carry over the balance and delete any out of pocket expenses.

I got caught out because the phone bill is paid every 1/4. I need to accumulate three monthly payments and then pay the bill. Is it possible to do this I think I need to use a DATE function. Is this possible?

 

[Scott1]

Can you be more specific?

 

[Eoghan]

I thought I had!

#all (most) payments are monthly, so I save the spreadsheet as the next month (August 2013.xl) delete out of pocket expenses, carry over the balance and everything is the same (not)
# the fly in the ointment is the quarterly phone bill. I can add it up manually in the quarterly billing cycle or I could see if there is a way to automate this on PuritanBoard.

 

[ooguyx]

If you want 1/3 of the bill to show up for each month's expenses:
There are a number of ways to accomplish this. I think the easiest would be to use the "paste special" command when copying and select 'Values' and 'Add' in the options box. This would add last month's balance to the quarter to date balance.

If you want only the full balance to show up on the payment month:
The DATE function in Excel is really about converting numbers into dates, which I don't think is what you're looking for. I think that you are looking for the MONTH function, which you would need to nest with the IF function. For instance if you want the number in the phone expense cell to be 0 for Jan & Feb, but 100 for March, the function would be: IF(MOD(MONTH(<<cell with the current month in it>>),3),0,100) of course this would change if your paying quarterly on the first or second months.

I hope that helps. Let me know if not.