Selecting Between Two Date Ranges (based on days in month)

I have a list of data that displays data by day, I want to select only the data for the for the current month and then the same day time frame for previous months in the data set.

E.g.

Today's date 08/07
Full days into month 7

Formula to sum data in columns B that only looks at dates 01/07-07/7
I will the adjust that formula for a January date that only pulls data for 01/01-01/07
Then repeat for Feb-June

I'm sure there was an easier way to explain this, hope it makes sense.

Assuming your dates are in column A, try this (e.g. in C1):

=SUMIFS(B:B,A:A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1),A:A,"<"&TODAY())

Hope this helps.

Pete

Thanks for the reply but that doesn't seem to work as I need it to.

Example.
My data is in a table in Sheet 2
My formula will be in Sheet 1 and will only extract data for the number days into the current month for each month

So, 7 days into July.
July is cell G1 and the formula in G2 will only return the 1st 7 days of data for July from the table in Sheet 2
June is cell F1 and the formula in F2 will only return the the 1st 7 days of data for June from the table in sheet 2
Same for Jan-May

I'm just going out now, but I'll pick this up later. In the meantime, why don't you attach a workbook which shows how your data is laid out - the FAQ describes how to attach a file to one of your posts.

Hope this helps.

Pete