Dear All Experts and Geniuses |

May I kindly request your help I need the two formulas in Cell G10 and Cell G11 to read from Cell G8 instead of Cell G9 |

Cell G10 =SUM(FILTER($D$6:$D$371,($B$6:$B$371>G9-IF(MOD(DAY(G9),7)=0,7,MOD(DAY(G9),7)))*($B$6:$B$371<=G9))) |

Cell G11 =SUMPRODUCT(($B$6:$B$371 > G9 - IF(MOD(DAY(G9), 7) = 0, 7, MOD(DAY(G9), 7))) * ($B$6:$B$371 <= G9) * ($D$6:$D$371)) |

Any assistance is greatly appreciated. |

Regards |

P.S. At home I use 365 Microsoft at the office some colleagues and myself use Excel 2016 |

The formula in Cell G10 was a great help from expert AliGW |