得到上周一的日期

Question

朋友们帮帮忙写个函数我急用

Answer 1

用weekday得到今天星期几再稍做调整
问题是“上个周一”的定义。例如2006.2.26是星期日，那么上个周一是指2006.2.20还是2006.2.13？？？？？

Answer 2

dateadd("d",now,-(weekday(now,vbMonday)-1)-7)

Answer 3

类似的，要得出上周二的日期
dateadd("d",now,-(weekday(now,vbMonday)-2)-7)
得出上周三的日期：dateadd("d",now,-(weekday(now,vbMonday)-3)-7)
得出上周四的日期：dateadd("d",now,-(weekday(now,vbMonday)-4)-7)得出本周四的日期：dateadd("d",now,-(weekday(now,vbMonday)-4))