Re: Counting weekdays between two dates @heidigray You only need to include the question about the calendar week in your formula. The WEEKNUM() function cannot represent an array, so I have packed this into INDEX() and SEQUENCE(). Of course, it also works with BYROW() if you already ...
Re: Counting weekdays between two dates @heidigray You only need to include the question about the calendar week in your formula. The WEEKNUM() function cannot represent an array, so I have packed this into INDEX() and SEQUENCE(). Of course, it also works with BYROW() if you already ...
I created to columns in One of my Calender WeekDay = WEEKDAY('Compare Date'[Compare Date]) WeekDay = WEEKDAY('Compare Date'[Compare Date]) And I able to sum same within this calendar Also There is another Calendar not join to this one, Able to do with that to Weekdays Second Cal ...
The chart above shows 4 different methods for counting from 1 to some number up to 8000. The painfully obvious loser in this race is the rCTE (the Red line). The "bumps" in the line show something else that I never expected; rCTE's are very sensitive to other things going on in the...
Re: Counting weekdays between two dates @heidigray You only need to include the question about the calendar week in your formula. The WEEKNUM() function cannot represent an array, so I have packed this into INDEX() and SEQUENCE(). Of course, it also works with BYROW() if you already ...