I need help with a formula. I need the formula to read a date and return the data for the line and column. i also need it to return the sum of the column by week, by month, by year. I have the daily data worked out by changing the date in cell A2. I can not figure out the week, month , year sums.
Solved by K. D. in 21 mins