摘要: Create a column, as below:The formula as below:Using the same technique you can also use the following formula: The current week (Sunday to Saturday inclusive)Start Week =[Due Date] - WEEKDAY([Due Date]) +1End Week =[Due Date] +7 - WEEKDAY([Due Date])The previous monthStart Month =DATE(YEAR([Due Dat 阅读全文
posted @ 2011-01-11 14:35 LeimOO 阅读(471) 评论(0) 推荐(0) 编辑