Spreadsheet: 130465d1322331325-date-formulas-sample-of-budget
Sheet: OTHER SPENDING

OPTION HERE TO JUST BE ABLE TO SHOW THE CURRENT MONTH SO IF NOVEMBER WAS TO BE CHOSEN THEN FROM TODAYS DATE WOULD BE SHOWN UP UNTIL 30/11/2011 |  |  |  |  | OTHER
 |  | INCOME | OUTGOINGS | BALANCE | IN | FROM | STATUS | OUT | FROM | STATUS
 | 2011-11-28 00:00:00 | =INCOME!D5 AUTO GENERATED | =OUTGOING!D5 AUTO GENERATED |  | VALUE TO BE ADDED | NAME | CLEARED | VALUE TO BE DEDUCTED | NAME | CLEARED
 | 2011-11-29 00:00:00 | =INCOME!D7 AUTO GENERATED | =OUTGOING!D7 AUTO GENERATED |  | PROVISIONALLY IN | NAME | UNCLEAR | PROVISIONALLY OUT | NAME | UNCLEAR
 | 2011-11-30 00:00:00
 | 2011-12-01 00:00:00
 | 2011-12-02 00:00:00 |  |  |  |  | cell f4 shows value to be added as the status is cleared
 | 2011-12-03 00:00:00 |  |  |  |  | however f5 shows value to be allocated as spent but noticeably
 | 2011-12-04 00:00:00 |  |  |  |  | the above all being in a drop menu from column H
 | 2011-12-05 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED |  |  | with maybe another option to transfer to another account where
 | 2011-12-06 00:00:00 |  |  |  |  | the same budget would be implemented
 | 2011-12-07 00:00:00
 | 2011-12-08 00:00:00
 | 2011-12-09 00:00:00
 | 2011-12-10 00:00:00
 | 2011-12-11 00:00:00
 | 2011-12-12 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED
 | 2011-12-13 00:00:00
 | 2011-12-14 00:00:00
 | 2011-12-15 00:00:00
 | 2011-12-16 00:00:00
 | 2011-12-17 00:00:00
 | 2011-12-18 00:00:00
 | 2011-12-19 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED
 | 2011-12-20 00:00:00
 | 2011-12-21 00:00:00
 | 2011-12-22 00:00:00
 | 2011-12-23 00:00:00
 | 2011-12-24 00:00:00
 | 2011-12-25 00:00:00
 | 2011-12-26 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED
 | 2011-12-27 00:00:00 | =INCOME!D7 AUTO GENERATED | =OUTGOING!D7 AUTO GENERATED
 | 2011-12-28 00:00:00 | =INCOME!D5 AUTO GENERATED | =OUTGOING!D5 AUTO GENERATED
 | 2011-12-29 00:00:00
 | 2011-12-30 00:00:00
 | 2011-12-31 00:00:00
 | 2012-01-01 00:00:00
 | 2012-01-02 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED
 | 2012-01-03 00:00:00
 | 2012-01-04 00:00:00
 | 2012-01-05 00:00:00
 | 2012-01-06 00:00:00
 | 2012-01-07 00:00:00
 | 2012-01-08 00:00:00
 | 2012-01-09 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED
 | 2012-01-10 00:00:00
 | 2012-01-11 00:00:00
 | 2012-01-12 00:00:00
 | 2012-01-13 00:00:00
 | 2012-01-14 00:00:00
 | 2012-01-15 00:00:00
 | 2012-01-16 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED
 | 2012-01-17 00:00:00
 | 2012-01-18 00:00:00
 | 2012-01-19 00:00:00
 | 2012-01-20 00:00:00
 | 2012-01-21 00:00:00
 | 2012-01-22 00:00:00
 | 2012-01-23 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D6 AUTO GENERATED
 | 2012-01-24 00:00:00 | =INCOME!D7 AUTO GENERATED | =OUTGOING!D7 AUTO GENERATED
 | 2012-01-25 00:00:00
 | 2012-01-26 00:00:00
 | 2012-01-27 00:00:00 | =INCOME!D5 AUTO GENERATED BEFORE THE WEEKEND
 | 2012-01-28 00:00:00
 | 2012-01-29 00:00:00
 | 2012-01-30 00:00:00 | =INCOME!D6 AUTO GENERATED | =OUTGOING!D5 AUTO GENERATED AFTER WEEKEND
 | 2012-01-30 00:00:00 | < AUTO INPUTS SAME DATE AS ANOTHER TRANSACTION IS PRESENT | =OUTGOING!D6 AUTO GENERATED
 | 2012-01-31 00:00:00