Need to get weekly data?

Ozu

=COUNTIFS({New Hire/Replacements Range 7}, "EU", {New Hire/Replacements Range 1}, WORKDAY(TODAY(), 5))

Tried this formula but the result is zero which is wrong, can anyone please correct this?

Paul Newcome

In that case you will need to specify a range of dates. Using the WORKDAY function will only output a single date for you to match on.

Try this instead:

=COUNTIFS({New Hire/Replacements Range 7}, "EU", {New Hire/Replacements Range 1}, AND(@cell>= TODAY(), @cell<= WORKDAY(TODAY(), 5)))

Paul Newcome

What exactly are you trying to accomplish?

Carson Penticuff

WORKDAY(TODAY(), 5

This is going to return the date five working days from today. Is {New Hire/Replacements Range 1} a date column?

Ozu

@Paul Newcome I want to pull data for a week like the no. of orders that came in a week's time.

@Carson Penticuff Yes that's a date column

Carson Penticuff

{New Hire/Replacements Range 1}, WORKDAY(TODAY(), 5)

This portion of the formula will match only entries exactly five weekdays from the current day. Are you wanting to match all entries between today and five workdays into the future?

Ozu

@Carson Penticuff Yes that's exactly what I am looking for but my formula is not pulling any data. I don't know where in the formula I am wrong.

Carson Penticuff

Its hard to be specific without knowing exactly how you have your sheets setup. Something like this will give you the results for the next five working days.

Paul Newcome

In that case you will need to specify a range of dates. Using the WORKDAY function will only output a single date for you to match on.

Try this instead:

=COUNTIFS({New Hire/Replacements Range 7}, "EU", {New Hire/Replacements Range 1}, AND(@cell>= TODAY(), @cell<= WORKDAY(TODAY(), 5)))