Count IF formula

I need a formula that will count if days till due are between 0 (today) and the next 7 days AND if the status column is not complete.

This is not working for me.

=COUNTIFS([Days Till Due]@row > 0, [Days Till Due]@row < 8, ([Status]@row = "Complete", "")


Thanks all

Answers