Weekday as a default uses vbsunday as start of week...
(which you are using as well)
However what is M$ desides to change that to "System settings" or (the international) vbMonday? Then your lost again.
Therefor my suggestion would be use: Weekday(Date,vbsunday) = vbthursday
Regards
(which you are using as well)
However what is M$ desides to change that to "System settings" or (the international) vbMonday? Then your lost again.
Therefor my suggestion would be use: Weekday(Date,vbsunday) = vbthursday
Regards