I have an issue where the Period is not working properly and I am looking a formula that will give me a quick fix as I don't have access to the universe to change it. I tried using
=If [Date Paid] Between([1st April];[30th April]) Then Count([Transaction Reference])
this formula has validated but it is bring back the total count for the whole year rather than just the references for the transactions paid in April. Is there something I am doing wrong?