Asset Management - Due in 7 Days not working

mclyburn5

This is part of the asset management template. The stock formula has a category for assets due in 7 days. I wanted to change that to within 7 days, and I looked up this formula that is supposed to do the trick:

=COUNTIF({Sheet - Asset Management Sheet Range 2}, TODAY(7))

However, it is still only returning assets due in exactly 7 days. How can I get it to return assets within 7 days?

KPH

Hi @mclyburn5

You are correct, this formula

=COUNTIF({Sheet - Asset Management Sheet Range 2}, TODAY(7))

will count the rows where the date in "Sheet - Asset Management Sheet Range 2" is equal to Today's date plus 7 days.

To count rows where the date is before or on the date in 7 day's time you need to use a less than and equals sign like this (in bold):

=COUNTIF({Sheet - Asset Management Sheet Range 2}, <= TODAY(7))

(don't copy this as the comments format the < and = as an arrow - type it in)