i have created a table from A1:L4.
In that A1:L1 is dates and A2:L2 is the names of Weeks for above dates in A1:L1
and in A3:L3 names of the data and A4:L4 values of A3:L3 data
now, here i want to formulate, whenever the "Saturday" arrived in A2:L2,the AHR value of that saturday has to Come from SUM of the remaining weekdays(monday to Friday) AHR value.
Same as for Even Sunday also has to get the AHR as sum of the remaining days including saturday
in this table i have considered the sunday is the last day of the Week.
attached the sheet with Table reference.
could anyone help me out from this at the earliest.
Bookmarks