Need to get weekly data?
=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?
Best Answer
-
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)))
Answers
-
What exactly are you trying to accomplish?
-
WORKDAY(TODAY(), 5
This is going to return the date five working days from today. Is {New Hire/Replacements Range 1} a date column?
-
@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
-
{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?
-
@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.
-
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.
-
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)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!