Does this count the dates that are 10 days or more?

Abbie G ✭✭

08/12/21 in Formulas and Functions

=COUNTIF(DateColumn:DateColumn, >(TODAY() - 10))

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Answers

• 

  Abbie G ✭✭

  08/12/21

  And does this count 14 days or less?

  <(TODAY() - 14)

  0 · Share on FacebookShare on Twitter
• 

  Mark Cronk ✭✭✭✭✭✭

  08/13/21

  =COUNTIF(DateColumn:DateColumn, @cell>=TODAY(-10)) will count the dates that are within the past 10 days.

  Mark

  
  

  I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  1 · Share on FacebookShare on Twitter
• 

  Abbie G ✭✭

  08/13/21

  How do I write it so it counts the dates that are 15 days or more in the future from todays date?

  0 · Share on FacebookShare on Twitter
• 

  Mark Cronk ✭✭✭✭✭✭

  08/14/21

  =COUNTIF(DateColumn:DateColumn, @cell>=TODAY(15)) will count the dates that are 15 or more days in the future.

  Work?

  Mark

  
  

  I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list