D
David
Hello all,
I have constructed this
=SUMPRODUCT(--('Sites_A-K'!G:G=A2),--('Sites_A-K'!I:I< (date()-60)))
in my attempts to count the rows where column 'Sites_A-K'!G:G = A2 and
column 'Sites_A-K'!I:I is less than today minus 60 days.
Cell A2 is text. Column G is text. Column I is date format.
I'm not getting an error, the cursor goes to the date() section of the
formula. I have changed date() to today() and getting a #NUM! error.
Any assistance you can provide is greatly appreciated.
I have constructed this
=SUMPRODUCT(--('Sites_A-K'!G:G=A2),--('Sites_A-K'!I:I< (date()-60)))
in my attempts to count the rows where column 'Sites_A-K'!G:G = A2 and
column 'Sites_A-K'!I:I is less than today minus 60 days.
Cell A2 is text. Column G is text. Column I is date format.
I'm not getting an error, the cursor goes to the date() section of the
formula. I have changed date() to today() and getting a #NUM! error.
Any assistance you can provide is greatly appreciated.