Today Forumula Question

So I'm still learning formula's. I'm trying to create a formula in my sheet summary. I'm looking for a count of end dates thats within the next 4 days. from today. Here is my formula:

=COUNTIF([End Date]:[End Date], >TODAY(4))



Best Answer

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    Answer ✓

    I think you just have your sign flipped. What you have written is you want to return a count of all the End Dates that are greater than Today + 4. For today (October 16th), that would return a count for every cell whose date was greater than October 20th. If you want events happening in the next 4 days, you want to flip the sign like this:

    =COUNTIFS([End Date]:[End Date], <=TODAY(4), [End Date]:[End Date], >TODAY(-1))

    This says you want to return a count of dates within the next 4 days, inclusive of TODAY.

Answers

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    Answer ✓

    I think you just have your sign flipped. What you have written is you want to return a count of all the End Dates that are greater than Today + 4. For today (October 16th), that would return a count for every cell whose date was greater than October 20th. If you want events happening in the next 4 days, you want to flip the sign like this:

    =COUNTIFS([End Date]:[End Date], <=TODAY(4), [End Date]:[End Date], >TODAY(-1))

    This says you want to return a count of dates within the next 4 days, inclusive of TODAY.

  • Reggie Andaya
    Reggie Andaya ✭✭✭✭

    @David Tutwiler Thanks so much, that was it.

  • David Tutwiler
    David Tutwiler Overachievers Alumni

    No problem, glad you got it working.

    Would you mind marking the reply as the "Answer"? It will help people who might be searching for this solution find it faster.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!