i have created sheet for Sum of the Weekdays data on Weekend.
in Cell C1 given months from Jan to Feb with drop down oprtion and cell D2 given the year with drop down option.
From Cell C2:BL2 given the dates as 1 to 31, and in from C3:BL3 given the weekday names basing on the year, month and dates of the above cells with the formula as:
=DATE($D$1;MONTH(DATEVALUE($C$1&" 1"));C2)
from C4:BL4 given the data names and C5:BL5 give the data values
on whenever there is saturday and sunday then Sum of the Weekday data values have to arrive on Saturday and sunday for that i used the formula as
=SUMIFS($C5:I5;$C$4:I$4;K$4;$C$2:I$2;">"&K$2-IF(WEEKDAY(K$3)=7;6;IF(WEEKDAY(K$3)=1;7;-999))) and it was successful,
whenever we use to change the month under Cell C1, the below Week name Positions will change automatically in that case the above formula for Sum of the weekday Values needs to be changed manually,
So here i need a help for Automatic formula for sum of the Weekday values on Weekends irrespective Weekends Positions.
attached the sheet for reference.
Please anyone help me out on this.