I have a table -Table2- with a column called -Due Date- for various tasks. On a graph along side I want to have a count of the number of tasks I have due within a certain time frame.

I'd like to have 4 categories, Due Date: Today, Within 7 days, Within 4 weeks (or 28 days), within 6 months.

The formula for Today was easy, I entered: =COUNTIF(Table2[Due Date],TODAY())

I have little experience with formulas and I thought the other categories would be fairly straight forward but I have not been successful. For instance, i found this formula =SUM(IF(Table2[Due Date]>=(TODAY()-WEEKDAY(TODAY(),2)+1),IF(Table2[Due Date]<(TODAY()-WEEKDAY(TODAY(),2)+1+7),1,0),0)) ------- the problem with this one is that it's counting tasks due this calendar week, instead of within 7 days of the current date (example: today it's Friday the 17th, the above formula does not count tasks I have due the following Tuesday, the 21st. It does not count it because next Tuesday is not technically THIS WEEK. But I need the formula to count tasks due within the next 7 days regardless of whether it falls within the same calendar week. This goes for my formula for 'due date within 4 weeks' as well, I'm less worried about tasks due within October than I am about the next 4 weeks irrespective of the calendar month.

Thank you in advance for your help =)