I am using Excel 2003. I want to create a worksheet that has two columns:
one for expense and second for remaining cash. The worksheet has 31 rows for
31 days in a month. I want to input an expense on any given day, even
skipping days were no expenses occured and have only the cell next to the
expense cell show the remaining balance.

Example:
Day Budget amount $400.00
Expense Remaining Balance
1 $100 $300
2 (empty cell) (empty cell)
3 (empty cell) (empty cell)
4 $50 $250
5 (empty cell) (empty cell)
6 $100 $150
and so on, and so on, etc.

How can I accomplish this?