Hi,
I have a workbook containing several worksheets.

Each worksheet is a table of data covering one working week.

For each new day, the date is entered (for the first entry only) in the first column.

I have summed the data by week and produced various tables and graphs for this.

However, now I have been told I need to represent the data by month. Is there a way that I can construct a table based on month - ie for each month the formula possibly looks at data corresponding to cells below the first $$/05/$$ or something..?