Forum Discussion
Not able to count with COUNTIFS
I am having problem counting with COUNTIFS In a column of an Excel table =TEXT([@[Date: Referral Rx]], "mmmm") This shows the month in the column Then, I am counting the total of those in t...
This works fine to me.
=LET(targetDate, TEXT(TODAY(), "mmmm"),COUNTIFS(Table1[Month: Initial Referral Rx], targetDate))