I created a formula for a search of the current week, I ask if there are alternatives
Thank you for your cooperationCode:=SUMPRODUCT((YEAR($C$3:$AAC$3)=YEAR($B$14))*(ISOWEEKNUM($B$14)=$B$15)*(C4:AAC4="K"))
I created a formula for a search of the current week, I ask if there are alternatives
Thank you for your cooperationCode:=SUMPRODUCT((YEAR($C$3:$AAC$3)=YEAR($B$14))*(ISOWEEKNUM($B$14)=$B$15)*(C4:AAC4="K"))
Bookmarks