As the title says, I want to calculate the average and sum of an array for the CURRENT week, month, and year. (Assume a week runs Monday through Sunday).
The solution might look something like ???
Range("A1") = Application.WorksheetFunction.AVERAGEIF(SUM_RANGE, YEAR(DATE_RANGE), YEAR(NOW()))
Bookmarks