Answer the question
In order to leave comments, you need to log in
How to count unique cell values for the current week?
On one sheet there are, for example, several cells:
Date - where the date is indicated in the format 03/23/2019
And status - for example Status1, Status2, Status3
So how to calculate status2 values for the current week?
I use:
=COUNTIFS(ISOWEEKNUM(DATEVALUE('Database'!C:C)); ISOWEEKNUM(TODAY());'Database'!L:L; "status2")
But it doesn't work, what should I do? The database is one sheet, but is displayed on another.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question