I am trying to create a formula for cells in a column that determines if the date in this row is Monday and if true sums the values in another column and the 6 previous values in that column to determine the weekly value for the week ending on that Monday (value to include the Monday value of that week. Thanks for any assistance.
Bookmarks