Invoice no, Received date and WEEKDAY of received date where index of WEEKDAY of received date is between 1 to 5 (i.e. it should be Monday to Friday):
Invoice no. | Received date | WEEKDAY of received date |
INV0001 | 2008-07-19 | 5 |
INV0002 | 2008-08-28 | 3 |
INV0003 | 2008-09-23 | 1 |
INV0004 | 2007-08-30 | 3 |