Counting a date range

Susan van Niekerk

Hi all

I am trying to count dates in a column - so my column is a date column but does have text "Due" as well as dates - when action has been taken the guys type over the "due and enter the date

I have the formal counting the Dues but having issues counting anything that is a date

=COUNTIFS({Jan Actual Date 24}, AND(IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))))

=COUNTIFS({Jan Actual Date 24}, ISDATE(@cell), {Jan Actual Date 24}, AND(DAY(@cell) = 31, MONTH(@cell) = 12, YEAR(@cell) = 2024))

Not sure where I am going wrong

KPH

At a quick glance, it looks like you have one too many parentheses at the end of your first formula. Try:

=COUNTIFS({Jan Actual Date 24}, AND(IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))

For the second formula, I think you could simplify this to:

=COUNTIF({Jan Actual Date 24}, DATE(2024, 12, 31))

Let me know how that goes.