Today Forumula Question

Reggie Andaya

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

David Tutwiler

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.

David Tutwiler

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

@David Tutwiler Thanks so much, that was it.

David Tutwiler

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.