# Date is within 7 days of today calculation

Options

I have a date field (field name = Reim due date) that is a calculation based on another date field.

I am trying to create a countif summary sheet field that says 'count if the Reim due date is within the next 7 days.' Formula below is coming back unparseable.

=COUNTIF([Reim due date]:[Reim Due date]),>TODAY(+7))

• ✭✭✭✭✭✭
edited 01/07/21
Options

=COUNTIFS([Reim du date]:[Reim du date], >=TODAY(), [Reim du date]:[Reim du date], <=TODAY(7))

Did that work/help?

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Hi Andree - it didwork, thanks. Can you explain to me why the first formula did not work?

I need to understand so I don't repeat the problem.

Tanya

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

Happy to explain.

It didn't work because it looks at everything after TODAY +7, so for me, that would be the 7th of January + 7 days, so the 14th of January and after.

Make sense?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

yes, thanks Andree!

• ✭✭✭✭✭✭
Options

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!