I am using this to count the number of unique dates in a named range ForDates and it works fine to give me that count
=COUNT(IF(FREQUENCY(ForDates,ForDates),1))
I need a formula that will count the unique dates in ForDates for a given year, like the year that is in cell G20, how could I do that?
Thanks
=COUNT(IF(FREQUENCY(ForDates,ForDates),1))
I need a formula that will count the unique dates in ForDates for a given year, like the year that is in cell G20, how could I do that?
Thanks