Parsing Dates Into Archive Buckets in a Calculated Column in SharePoint
I needed to put sets of news articles into buckets in a list so that I could allow users to filter based on the time period in which the articles were published. To do this, I created a calculated column as a Site Column (for reusability). Column name: Archive Period Calculation: =IF([Publish Date]<([Today]-365),”Year” & TEXT(YEAR([Publish…