Try this in cell D2.Formula:
=SUMPRODUCT(--(WEEKNUM(+Table1[DUE DATE],1)=WEEKNUM($B$1,1)),--(WEEKDAY(+Table1[DUE DATE],1)=6))
Try this in cell D2.Formula:
=SUMPRODUCT(--(WEEKNUM(+Table1[DUE DATE],1)=WEEKNUM($B$1,1)),--(WEEKDAY(+Table1[DUE DATE],1)=6))
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks