Forum Discussion
Solved
MS Excel DAY/WEEK/MONTH Formula.
Hi Everyone! I want to count the running week days before today date with counting today, when it gets the dates then it count the dates related rows data and count them together and show it to the ...
I have rearranged your formula a little and also developed the one for the month. I think it should fit like this.
=SUMPRODUCT((Data_Sheet[Date and Day]>$C2-WEEKDAY($C2,16))*(Notice_Board[[#Headers],[Renting Cost]]=Data_Sheet[Type of Cost])*Data_Sheet[Cost (TK)])=SUMPRODUCT((Data_Sheet[Date and Day]>$C2-DAY($C2))*(Notice_Board[[#Headers],[Renting Cost]]=Data_Sheet[Type of Cost])*Data_Sheet[Cost (TK)])
I have rearranged your formula a little and also developed the one for the month. I think it should fit like this.
=SUMPRODUCT((Data_Sheet[Date and Day]>$C2-WEEKDAY($C2,16))*(Notice_Board[[#Headers],[Renting Cost]]=Data_Sheet[Type of Cost])*Data_Sheet[Cost (TK)])=SUMPRODUCT((Data_Sheet[Date and Day]>$C2-DAY($C2))*(Notice_Board[[#Headers],[Renting Cost]]=Data_Sheet[Type of Cost])*Data_Sheet[Cost (TK)])
