ffarshadd
06-09-2017, 06:19 AM
i have a column for dates. the other column is for numbers.
i need a vba code to calculate the average of numbers from (last Saturday to last Wednesday) of last week(not current week).
for example if today is Thursday i wanna have the average from (last Saturday to last Wednesday) of last week not this Wednesday.
i need a vba code to calculate the average of numbers from (last Saturday to last Wednesday) of last week(not current week).
for example if today is Thursday i wanna have the average from (last Saturday to last Wednesday) of last week not this Wednesday.