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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 201 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!