I am trying to count all rows that falls between any day of the previous month
I am using this formula but it is not working, can someone help me correct the formula?
=COUNTIFS(CreditBranch,I10,Credit_PullDate,">="&EOMONTH(A2,-2)+1,Credit_PullDate,"<"&DATE(YEAR(TODAY()),MONTH(TODAY()),0))
I am using this formula but it is not working, can someone help me correct the formula?
=COUNTIFS(CreditBranch,I10,Credit_PullDate,">="&EOMONTH(A2,-2)+1,Credit_PullDate,"<"&DATE(YEAR(TODAY()),MONTH(TODAY()),0))