Sharepoint 列表按月分组显示

如果你有一个sharepoint列表包含一个日期的列，你可能想要创建一个按月分组的视图。例如：在一个任务列表中，你能创建一个按月分组的视图。

首先，创建一个计算列，让它返回一个文本值并在计算公式(Formula )输入框中输入如下公式：

=YEAR([Due Date])&"-"&CHOOSE(MONTH(DATEVALUE("1/"&MONTH([Due Date])&"/"&YEAR([Due Date]))),"01. January","02. February","03. March","04. April","05. May","06. June","07. July","08. August","09. September","10. October","11. November","12. December")，其中Due Date为已存在的日期类型的列。