Hello,
I have a column with dates for a month in descending order. I have another column where I manually enter values of work received on those days. Now, I want to create a formula that locates each Monday, then refers to the column immediatly to the right of the date in order to return a daily average of work received.
The reason I want to do this is because I create a new worksheet each month and it would save me a lot of time of manually changing my formula and picking out each Monday by hand.
Example :
Monday 46
Tuesday 77
Wednesday 12
Monday 36
I need the formula to automatically find the 46, 36, then return an average. Thank you!
Bookmarks