Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to increment budget automatically when entering a date?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically entering date | Excel Discussion (Misc queries) | |||
Automatically entering date | Excel Discussion (Misc queries) | |||
Automatically entering time and date to an entry | Excel Discussion (Misc queries) | |||
automatically increment field by one | Excel Discussion (Misc queries) | |||
increment cell value automatically | Excel Worksheet Functions |