Counting a date range

Options

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

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!