Why cant I count in this date range?

RickyT

Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ?

=COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1)))

Anyone help me with the syntax here?

Toufong Vang

Try this...

=COUNTIF([RLO Receive Date]:[RLO Receive Date], AND(@cell>=DATE(2024,1,1), @cell<=DATE(2024,4,1)))

You want both conditions to be true, "greater that or equal to 2024-01-01" and "less than or equal to 2024-04-01", so wrap the criteria within AND().

Also, your original formula had an extra ")".

Toufong Vang

Try this...

=COUNTIF([RLO Receive Date]:[RLO Receive Date], AND(@cell>=DATE(2024,1,1), @cell<=DATE(2024,4,1)))

You want both conditions to be true, "greater that or equal to 2024-01-01" and "less than or equal to 2024-04-01", so wrap the criteria within AND().

Also, your original formula had an extra ")".