G
gzevspero
Hi,
I'm trying to setup a budget worksheet so I can (finally) organize my
personal finances. What I'm trying to do is have a field where I can enter a
date and see my projected balance for that date. This means that several
fields containing the various projected expenses and incomes would need to
update my balance automatically, based on how much time has passed from now
until the date I entered. For instance, if my current balance is $1000 and I
have a credit card payment of $50 due on June 23rd, a $2000 paycheck to be
deposited July 1st, and $500 rent due on the 11th, if I enter July 12th into
this field, I'd like it to show a balance of $2450. It'd be nice if I could
also set it up to view a date several months in advance and have it update
automatically for those months. Can anyone help out?
Thanks a lot.
I'm trying to setup a budget worksheet so I can (finally) organize my
personal finances. What I'm trying to do is have a field where I can enter a
date and see my projected balance for that date. This means that several
fields containing the various projected expenses and incomes would need to
update my balance automatically, based on how much time has passed from now
until the date I entered. For instance, if my current balance is $1000 and I
have a credit card payment of $50 due on June 23rd, a $2000 paycheck to be
deposited July 1st, and $500 rent due on the 11th, if I enter July 12th into
this field, I'd like it to show a balance of $2450. It'd be nice if I could
also set it up to view a date several months in advance and have it update
automatically for those months. Can anyone help out?
Thanks a lot.