# Today Forumula Question

Options
✭✭✭✭

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

• Overachievers Alumni
Answer ✓
Options

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

• Overachievers Alumni
Answer ✓
Options

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.

• ✭✭✭✭
Options

@David Tutwiler Thanks so much, that was it.

• Overachievers Alumni
Options

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!