I've created a spreadsheet for budgeting purposes and to keep track of my money (student). I know that on certain days (like Payday) the amount I will be paid and obviously the date. I want to be able to put this in my table but not to be added to the formula until that date is passed or met.
For Instance,
If I get paid on 01/09/10 and put this in my table, the formula will add this amount to the total income for the month of September. The funds have not actually been paid to me however, so they need to be excluded until they are paid i.e on the 01/09/10.
Does this make sense?
Thank You
For Instance,
If I get paid on 01/09/10 and put this in my table, the formula will add this amount to the total income for the month of September. The funds have not actually been paid to me however, so they need to be excluded until they are paid i.e on the 01/09/10.
Does this make sense?
Thank You