Countif by month if due date is next month

Ken Hoffman

Hello Community,

I am having an issue with my formula. I am trying to give my client a SLA timeline on when quotes are due and overdue on a month-to-month basis. Currently my data sheet is counting the quotes per month and if we get the quote in within XX number of days then we get a complete. The issue is if a quote was requested in September but due in October my Data Sheet does not reflect the quote was completed on time in the right month. How can I fix?

Michael Culley

Could you not just change the range to search the Date Requested column instead of Date Submitted?