Afternoon happy campers,
Excel sheet, Column A 'Week Num'
Column A 'Week Num'
Column B 'Date'
Column C 'Qty'
I would like a cell on the sheet to look at what week number we are currently in, count back 17 weeks, and then show me an average.
Sample attached may help explain a bit better.
(in Sample, yellow coloured area is the previous 17 weeks (FULL weeks) from todays week number.
Kind regards
galvinpaddy
Bookmarks