Hi

We have a spreadsheet with 1100 rows of data with columns of date,
amount (either positive or negative), description and balance.

We would like to chart this but it is a lot of data so we may want to
chart over 2 months on a daily balance, over 6 months an end of week
balance or over a year on end of month balance.

How can we manipulate this data to get the end of week or end of month
balance? Daily we have used subtotal but how to do this for end of
week (say each Friday) and end of month?

Thanks in advance
Leanne