'Smart worksheet'

  • Thread starter Thread starter Lorraine.vdWalt
  • Start date Start date
L

Lorraine.vdWalt

This is probably quite basic really but it's really got me - i'm stuck.
I want to update by personal budgeting spreadsheet so that i have less
updating and fiddling to myself.
i try to make it as much like my bank statement as possible, so date,
description, credit, debit, balance collomns; However i would like to be able
to get the sheet to recognise weeks as present i have week collumns which i
workout myself. I get paid weekly so it would be be really helpful if someone
new a way to do this and also if a can create a 'pick list' or something so
that it can update or 'fill in' the next months details for me, any
help/pointers will be greatly appreciated
 
Don't know if I'm following you.

If you're interested in labeling your columns with calculable weekly dates,
you might try using 2 rows for each column header.

Format the upper row with the first day of the appropriate week, and the row
below with the ending day (date).

In the next column, just add 7 to automatically get your next set of dates.

For example, in B5 enter:
7/19/2009
And in B6 enter:
7/25/2009

Then, in C5 enter:
=B5+7
And in C6 enter
=B6+7

Now, select *both* C5 and C6, and drag across as needed to fill in your
range of dates.

You now have "legal" XL dates in your header.

You can now construct your formulas to include say:
=D5, <=D6
Click to expand...
to have the correct values calculated that fit the referenced time frame.
 
Back
Top