Hi All,

Hoping somebody can help me with a formula I need in Excel 2013.

I have a number of accounts and need to provide some basic MI, one piece of information I need is the number of cases that were registered in a particular month.

So I have a column for Date Received which is I3 and then I need a COUNTIF that picks up the number of cases within a given month but for three separate criteria's (received, open, resolved). For example I have Feb cases, I need a formula to pick up how many cases received between 1st - 28/29th Feb that are currently resolved and then a separate formula to pick up the same info but if the criteria is open, the data for whether the case is open or resolved is in column AN3.

Also is it possible for me to highlight/count any that fall outside of an SLA, so for example I have 300 cases, an SLA to resolve them within 10 days, so a formula that picks up from date received whether the case is outside of SLA.

Kind Regards