【参考】SharePoint计算列快速参考

以下公式表引用自网站：http://blog.pentalogic.net/2011/05/sharepoint-calculated-column-cheat-sheet/

【补充公式】：
1. 给个日期字段增加时间：=[Start Time] + TIME(1,35,10)

2. 有时，按分钟计算的时间会有1分钟的误差。这是因为INT函数截取而不是四舍五入了精确的数字。所以可用如下公式代替：
=ROUND(SUM([SecondDate],-[FirstDate])*1440, 0)

3. 日期所在周周一：[TheMonday]=[InputDate]-WEEKDAY([InputDate],3)
以周一为一周首日，格式形如“2013-W05”的年周次：[TheYearWeek]=IF(ISBLANK(TheMonday),"",YEAR(TheMonday+5-WEEKDAY(DATE(YEAR(TheMonday),1,1)))&"-W"&TEXT((TheMonday-DATE(YEAR(TheMonday+5-WEEKDAY(DATE(YEAR(TheMonday),1,1)))-1,12,31)+WEEKDAY(DATE(YEAR(TheMonday),1,1))-5)/7+IF(WEEKDAY(DATE(YEAR(TheMonday+5-WEEKDAY(DATE(YEAR(TheMonday),1,1))),1,1))<6,1.5,0.5),"00"))
 

关于时区及不同文化下的日期约定参见：
http://www.timeanddate.com/calendar/custom.html?year=2010&country=5&lang2=0&cdt=1&typ=0&display=3&df=1
http://www.timeanddate.com/calendar/custom.html?year=2010&country=5&lang2=0&cdt=1&typ=0&display=3&df=1

另，关于计算列可参考如下文章：

http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/
http://blog.pentalogic.net/2008/10/advanced-sharepoint-view-and-filters/
http://blog.pentalogic.net/2009/11/howto-filter-items-current-calendar-month-view-sharepoint/