I have created a table that displays the weekdays of the month, who has the
highest commission and how much they earnt in the form:

Date | Seller| Commission | Day of the Week
01/06/09 | XX | £YY | Monday
02/06/09 | ZZ | etc....

There is also a box on the sheet near the top where you select todays date
(which is used for an entirely different function.)

The table is used for management purposes only, but a shorter version will
be made public to the sales team. This needs to display the last 5 week - ie,
working - days and the top seller and commission for that day. This will take
a similar form:

Day | Seller | Commission
Monday | X | £
Tuesday | X | £
Wednesday | X | £
Thursday | X | £
Friday | X | £

Although it wont necessarily be in that order. as it is the last 5 working
days it may be: thurs, fri, mon, tues, weds; or whatever the case may be.

I am not entirely sure about the best foruma to use to create this table. My
thought is to use a VLOOKUP on the "todays date" box (mentioned earlier) to
look for the preceding weekdays date, 2 precedinging weekdays and so forth,
on the initial table and displaye the corresponding day, seller and
commission data. My main problem is working it so it only uses weekdays.

Any suggestions? Thanks