Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Formula help: Count how many dates are from the last week and the coming week

I am trying to do an equation in sheet summary that will calculate how many dates were in the last 7 days and are scheduled in the next 7 days.

This is what I have, I've tried others on community questions that were close and figured I would just ask.

=COUNTIFS([Start Date]:[Start Date], @cell <= TODAY(-1), @cell > TODAY(-7))

Tags:

Best Answer

  • Community Champion
    edited 06/17/24 Answer ✓

    =COUNTIFS([Start Date]:[Start Date],AND(@cell <TODAY(), @cell >= TODAY(-7))) is the last 7 and

    =COUNTIFS([Start Date]:[Start Date], AND(@cell >TODAY(), @cell <= TODAY(+7))) are the next 7

    if your wanting to add them together.

    =COUNTIFS([Start Date]:[Start Date],AND(@cell <TODAY(), @cell >= TODAY(-7)))+COUNTIFS([Start Date]:[Start Date], AND(@cell >TODAY(), @cell <= TODAY(+7)))

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions