Hello,

In A1 I have a date (this will be the end date for a commission cycle of 14
days)

In B1 I have my name (for this formula we will call me Jim)

In column E I have dates for the last year. In the F column I have the
names of my sales people.

in columns G:J I have data.

I need help with a formula that will match the name (B1) as well as average
column G for the date in A1and the 13 previous days.

Thank you in advance for the help. I appreciate your time.