Count tasks between today and xdays+today

Dvenegas

I have several different project sheets that contain communication tasks.  I create another sheet to create a count of tasks coming up in the next 7 days (I plan to create a report to pull up to a dashboard).  I am having trouble creating a formula that will count the tasks between today and today +7 days.

This is what I have and it's not working    

=COUNTIF({EDM - Communication Schedule Range 3}, <=TODAY(7) >= TODAY())

Paul Newcome

Try something like this...

 

=COUNTIFS({EDM - Communication Schedule Range 3}, AND(@cell <= TODAY(7), @cell >= TODAY()))