Two dates between Now and +7 Days

Hi I am trying to return a count of dates between two dates that will move based on todays date, I have tried umpteen different approaches but cannot get the sheet to return a valid answer.

=COUNTIF(MigrationDate1:MigrationDate3, >TODAY() <= TODAY(+7))




The answer it returns is 3. I would have expected it not to count 05/08/20.

Seems like a really simple calculation but i cannot get it to work. Any help appreciated.

Best Answer


  • That worked, thank you for the prompt info.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!