Why cant I count in this date range?

Options

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?


Ricky T

Gov Contractor for USSF

Tags:

Best Answer

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓
    Options

    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 ")".

Answers

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓
    Options

    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 ")".

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!