filter dates by quarter
Hi Larry
In cell J14
=AVERAGE(OFFSET(I14,0,0,-13,1))
would give the average of the previous 13 weeks Gross
--
Regards
Roger Govier
"Larry" wrote in message
...
Im working on a spreadsheet for my payroll, in column
A is a weekly pay period end date
I is my gross pay for that week
Holiday pay is figured on a weekly average of the last quarter gross pay.
How do I filter the date per quarter and then average the gross for that
quarter?
|