Count tasks between today and xdays+today

06/28/19 Edited 12/09/19

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())

Popular Tags:


  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try something like this...


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

Sign In or Register to comment.