Sum the digits in a row only if the column header date is not past today-7 days

[Dukegijoe]

I have an excel sheet that I am using to determine Estimates to Complete (ETC). The Rows represent various Work Breakdown Structure (WBS) Tasks, where each column represents the start of a given week. The client does not want the previous week's data to be deleted, but I am still trying to provide ETCs for the current week and going forward. Is there a way to write the formula so that it ignores the weeks that are in the past but will still sum the values in the row across all the columns starting with the current week and going forward.

File Attached

[protonLeah]

Please Login or Register  to view this content.

[Phuocam]

Try this:

=SUMIFS(B3:AC3,$B$2:$AC$2,">"&TODAY()-7)

[Dukegijoe]

Thank you Phucam. It was very helpful.

ProtonLeah the problem I was running into was the "-7"

Thank you both.