Forum Discussion

Atom0aks's avatar
Atom0aks
Copper Contributor
Dec 28, 2023

COUNTIFS comparing columns for overdue dates

Hi,

 

My objective is to count all overdue dates in 2023,

 

EF
DueDelivered
08-Aug-2207-Dec-22
14-Dec-2202-Feb-23
29-Jul-2211-Aug-22
11-Nov-2229-Dec-22

 

The result should be "1" but Excel returns a "0" when I use this formula,

 

=COUNTIFS(F:F,">=31-Dec-22",F:F,"<=01-Jan-24",F:F,">"&E:E)

 

Any help would be greatly appreciated. Thanks!

excel
Formulas and Functions

9 Replies

Sort By
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 28, 2023

    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)
)
    • Atom0aks's avatar
      Atom0aks
      Copper Contributor
      Dec 28, 2023

      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.

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Dec 28, 2023
        OK, I see. What version of Excel do you run?

Resources