I am trying to create an IF(AND) statement, but I cannot figure it out.  Any help would be greatly appreciated.

I am trying to write a formula that will check the "at risk" if the the "done" column is not checked and the due date is 7 days before today.


I'm trying to create a chart that counts the number of entries in a particular column.  eg a column which lists employee names.  How do i produce a chart which tells me how many rows that name appears in?

Thanks in advance for any