Date is within 7 days of today calculation

Tanya Brooks

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))

Andrée Starå

Hi @Tanya Brooks

Try something like this instead.

=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

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tanya Brooks

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

Andrée Starå

@Tanya Brooks

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?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tanya Brooks

yes, thanks Andree!

Andrée Starå

@Tanya Brooks

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!