Forum Discussion
COUNTIFS comparing columns for overdue dates
Hi, My objective is to count all overdue dates in 2023, E F Due Delivered 08-Aug-22 07-Dec-22 14-Dec-22 02-Feb-23 29-Jul-22 11-Aug-22 11-Nov-22 29-Dec-22 The re...
Hi Atom0aks
Could you try the following & let me know what doesn't work (something isn't clear to me)?
in H2:
=COUNTIFS(
F:F,">=" & DATE(2022,12,31),
F:F,"<=" & DATE(2024,1,1)
)
Hi!
Your formula counts the number of dates in 2023. If you add another row of data (e.g. Column E, 31-Dec-23; Column F, 13-Oct-23), the formula will return "2" when only 1 row of dates is overdue.
I need an additional criteria counting delivery dates in 2023 that are greater than the due date.