Hello,
I'm trying to count the number of cells that have a date in the year 2020. This is the formula that is returning "0" which is incorrect:
=COUNTIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], >=DATE(2020, 1, 1))
Additionally, I want to sum the values that correspond to this date range, and this formula is returning an invalid operation error:
=SUMIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], >=DATE(2020, 1, 1), [Proceeds Amount]:[Proceeds Amount])