Function DoWDay$(dd$) Select Case DayOfWeek(val(mid$(dd$,7,4)),val(mid$(dd$,4,2)),val(left$(dd$,2))) Case 0:DoWDay$="Sun" Case 1:DoWDay$="Mon" Case 2:DoWDay$="Tue" Case 3:DoWDay$="Wed" Case 4:DoWDay$="Thu" Case 5:DoWDay$="Fri" Case 6:DoWDay$="Sat" End Select End Function