Average productivity for the past 7 WORKING days

Hello all! I am reposting this after prematurely marking it solved.

I have 2 rows of data...

Row one has a series of sequential dates, ie: 3/22/2016, 3/24/2016, 3/25/2016 ect..
Row two has a simple number of widgets per day , ie: 5 12 6

This data set will continue to grow across the sheet as time goes by.

What I am looking to do is show the average number of widgets for the past 7 working days from todays date. The result is needed for a daily dashboard showing the running average for the past 7 working days only (Monday- Friday)

The formula should ignore Saturdays and Sundays!

Thanks as always!!

See if this work for you
Use this formula in H3 and copy right to obtain the average of 5 past working days from the date in H1.
=IF(WEEKDAY(H1)<6,SUMPRODUCT(--(WEEKDAY(B1:H1)<6)*B2:H2)/5,"")
Where row 1 and row 2 from column B has your date and value respectively.

Let's say your dates are in A1:Z1, and the values to average are in A2:Z2

=AVERAGEIFS(A2:Z2,A$1:Z$1,">="&WORKDAY(TODAY()+1,-7),A$1:Z$1,"<="&WORKDAY(TODAY()+1,-1))

Thanks guys.. I am traveling this day, once I land I will test and report back!!

I uploaded a workbook.. try both suggestions gets me very close but seem to ignore Friday and Saturday rather then Saturday and Sunday??

Hi
Try this in G3 and copy right
=IF(WEEKDAY(G1,2)<6,SUMPRODUCT(--(WEEKDAY(A1:G1,2)<6)*A2:G2)/5,"")
See the file WeekDay Average(1).xlsx

Thanks for all your help Jose.. That worked perfect!