hi

culoumn a is date

column b is numbers

c1 cell is a report as at today input

how do i write a formula to sum the contents of column B based on there date
been in the last 7 days from report date