Hi guys,
i'm not able to construct a formula to solve this problem.
Column B is filled from row 12 to 4000 with dates. (dd/mm/yyyy)
Cell C2 contains the current yearNow I want a formula that counts how many times the year in cell C2 appears in the dates from column B.Please Login or Register to view this content.
I've tried with countif and sumproduct and other things I found online but nothing seems to be working properly.
Thanks in advance.
Bookmarks