1
I have a table (google Sheets) that generates dynamically, by choosing the month, a calendar sheet formatted with different colors for weekends and holidays. I intend to add the weekly hours on the last working day of a week (column D), but not including hours from the previous week, as is happening in the following figure. I have already arranged for the sum to be made only on Friday or on the last day of the month. But as the range I have is fixed, it happens the problem that the following figure documents.
What I need is a way to make the summation range dynamic (Bold in the following formula) to include only the days of this week (the column F contains the date value of each day used in the application of the function fimmês().
The conditional sum formula I have in the column cells D is the following:
=SE(OU(A43="SÁB";A43="DOM");"";SE(OU(A43="SEX";F43=FIMMÊS($F$18;0));**SOMA(C39:C43)**;""))
