CountIfs Question

[richtks]

Hello again.

I'm trying to utilize CountIfs to determine workflow...

=COUNTIFS(Details[Market Combined],[@Market],Details[4225:Year],"=2024",Details[4225:WK],">=16",Details[4225:WK],"<=19")

instead of having to manually change the weeks (Row [4225:WK]), I'd like to just set a date range of 28 days prior to "today()" (basically 4 weeks).

Any advise?

 

[awoohaw]

you have this:

=COUNTIFS(
Details[Market Combined],[@Market],
Details[4225:Year],"=2024",
Details[4225:WK],">=16",
Details[4225:WK],"<=19")

In what part of that do you want to use today()-28?
Or is it a different column in the table?

 

[richtks]

you have this:

=COUNTIFS(
Details[Market Combined],[@Market],
Details[4225:Year],"=2024",
Details[4225:WK],">=16",
Details[4225:WK],"<=19")

In what part of that do you want to use today()-28?
Or is it a different column in the table?

I'm wanting to replace the [4225:WK],">=16" & [4225:WK],"<=19", which are week's 16 and 19 and just go with today - 28 days. I would use the dates in my "Details[PJ(4225) Construction Start]" Column

 

[Cubist]

Try:

=COUNTIFS(Details[Market Combined],[@Market],Details[4225:Year],"=2024",Details[4225:WK],">="&TODAY()-28,Details[4225:WK],"<="&TODAY())

 

[Fluff]

Another option

=COUNTIFS(Details[Market Combined],[@Market],Details[PJ(4225) Construction Start],">="&today()-28,Details[PJ(4225) Construction Start],"<="&today())