I’m looking for a excel formula that will provide average sales before and after a date when a facility was closed.   In column A I have the facility location #, and in the row going across I have weekly sales data from 2022 to 2024: During the time of 1/10/2023 to 2/10/2023 the facility was down, and the formula I’m trying to write would provide the Average weekly sales for 5 wks prior to the facility closing on 1/10/2023, then the average weekly sales 4 weeks after the facility re-opened on 2/10/23.

​I’m looking for a excel formula that will provide average sales before and after a date when a facility was closed.   In column A I have the facility location #, and in the row going across I have weekly sales data from 2022 to 2024: During the time of 1/10/2023 to 2/10/2023 the facility was down, and the formula I’m trying to write would provide the Average weekly sales for 5 wks prior to the facility closing on 1/10/2023, then the average weekly sales 4 weeks after the facility re-opened on 2/10/23.  Read More

​