combined Countif and weekday function
I have a sheet which has a date field. This field is filled in with a date based on the date to which something occurred.
I have helping columns in that same sheet that extracts only the Month, Date, and weekday based on date field. With the "helping columns" on a different sheet which i'm calling "stat sheet" i'm counting how many "Sundays" represented by the number "1" there are in totality so i can graph the weekdays and month of the year.
My question is this.
On my stat sheet, is it possible to do a countif and weekday function in order to get rid of the need of using the "helping columns"
I'm using the following text, can someone please tell me what i'm doing wrong.
=COUNTIF(WEEKDAY({BPD DTU Responses Range 6}), "1")
Answers
-
I was trying it with this formula, but I can only get it to return "1" for a value. I know there are bunch of matching dates in the column. Try it and see if it does the same for you.
=COUNT(COLLECT({BPD DTU Responses Range 6}, WEEKDAY(@cell), 1))
-
I'm also getting the result of 1.
Just to clarify my intent though, i'm not really tring to collect anyhing, in all reality there is only 1 criteria i am trying to search against.
Using the "weeday" function from the date: =weekday(date) illustrated below I get the appropriate number using a helper field. I'm just trying to accomplish the same thing without the helping field.
Count the number of records in the "date" column where the weekday = "1" where 1=Sunday.
Date day of week field
10/10/21 1
10/10/21 1
10/10/21 1
10/13/21 4
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!